Right now, my fav is "Made in the Shade" by arbonne.com -- it's one of the few that contains a sunscreen, doesn't smell too nasty, nice color, easy spray, plus it develops SOME color within 2 - 3 hours, although best color is within 8 hours. I like to apply at night, then shower/touch up in the morning. Once a week or so keeps me looking good.
If you want to spray and go -- and have INSTANT color -- MagicTan is better than Mystic Tan, but the downside is that Magic Tan is a whole lot streakier on the feet/knees.
I use vinyl or latex gloves to apply the stuff -- that way, my palms aren't orange.
I freckle-tan, and cuz I don't love freckles, I stay out of the sun. Good move, because my skin looks waaaaaaaaay better than any other mom my age.
AVOID SUN BEDS AND SOLAR TANNING!!!!