I'be been happy with one from Neutrogena that has spf and face tanner. I don't really notice the color on my face, but that may be because I have been using it (or another like it) for some time now. Probably adds some healthy "glow" and that is about it.
Cetaphil is great stuff. Olay's Regenerist line has been getting really good reports, I have the Serum and have been quite happy with it. Not quite as wonderful as Estee Lauders's Idealist, but pretty close for a lot less.