I never buy SanDisk, as they have been the only brand that I've had issues with.
I have two 1GB kingston CF's for my wife's Canon S400 (elph) and they work out great. I do have issues in my Olympus C-5050Z, but I think that's due to the size, as the problems only arise after about 800-900MB of shots are on the card; I think it's the camera's OS.
Lexar is my prefered media brand (made by Panasonic). It is quite nice.