Our colleagues over at Re-Nest have been waging war, pitting an assortment of light bulbs against one another to find which lighting solution not only is the most energy efficient, but more importantly, which provide the most eye-pleasing light. Here's the results thus far (gallery above showing overall score and detailed review link)...
Bulbs reviewed so far:
RECOMMEND
GE Energy Smart LED, 9 Watt - RECOMMEND
EcoSmart A19 8.6-Watt LED - RECOMMEND
Sylvania Living Spaces CFL - RECOMMEND
Philips AmbientLED Indoor FloodM - RECOMMEND
GE 13-Watt Energy Smart - RECOMMEND
Plumen 001 - RECOMMEND
Philips 12.5W AmbientLED A19 - STRONG RECOMMEND
WEAK RECOMMEND
Pharox 300 Dimmable LED - WEAK RECOMMEND
Philips R30 Reflector Flood - WEAK RECOMMEND
EcoSmart Soft White CFL 40W Equivalent - WEAK RECOMMEND
100 DIY Ideas for the 3-Day Weekend
Danielle's Charming, Classic Walk-Up
Good Food to Share 
The Big Book of Small, Cool Spaces 
Apartment Therapy Presents 
The Eight-Step Home Cure 
White Enamel Flatwa...
How To Cook Fluffy, Tasty Quinoa
Perfect Summer Cocktail Recipe: Honey Bourbon Lemonade
To save anyone the trouble:
GE Energy Smart LED, 9 Watt - RECOMMEND
Pharox 300 Dimmable LED - WEAK RECOMMEND
EcoSmart A19 8.6-Watt LED - RECOMMEND
Sylvania Living Spaces CFL - RECOMMEND
Philips R30 Reflector Flood - WEAK RECOMMEND
Philips AmbientLED Indoor Flood - RECOMMEND
GE 13-Watt Energy Smart - RECOMMEND
Plumen 001 - RECOMMEND
EcoSmart Soft White CFL 40W Equivalent - WEAK RECOMMEND
Philips 12.5W AmbientLED A19 - STRONG RECOMMEND
Edwood, you are awesome.
To save anyone even more trouble!
STRONG
GE Energy Smart LED, 9 Watt - RECOMMEND
EcoSmart A19 8.6-Watt LED - RECOMMEND
Sylvania Living Spaces CFL - RECOMMEND
Philips AmbientLED Indoor Flood - RECOMMEND
GE 13-Watt Energy Smart - RECOMMEND
Plumen 001 - RECOMMEND
WEAK
Pharox 300 Dimmable LED - WEAK RECOMMEND
Philips R30 Reflector Flood - WEAK RECOMMEND
EcoSmart Soft White CFL 40W Equivalent - WEAK RECOMMEND
Philips 12.5W AmbientLED A19 - STRONG RECOMMEND
These reviews seem to use a very subjective assesment of the color of the light, and don't discuss how well the color of objects (or people!) lit by the bulb is rendered. There's a normal standard for this called CRI, but it tends to represent LED bulbs inaccurately (they get inflated scores), so NIST's new Color Quality Scale is a better approach. This overview is helpful, but as a photographer (and a person with sensitive vision!) it'd be far more useful if the reviews went into detail on this.