I read something a while ago about different cultures, and their preferences for different kinds of light. I believe North Americans tend to like the soft yellow, while many Asian cultures are more comfortable with crisp white. Although, I grew up here, so I'm not sure where my preference comes from.
I have a white CFL desklamp in my home office, and by a chair in the corner I have a yellow corner lamp (admittedly incandescent not LED).
I prefer to do casual reading/relaxing under yellow light ("mood lighting"), and work/bathroom under white light.
This may seem like a binary issue, but really it comes down to setting and personal preference for the light used therein.
"Find out what you want, and then learn to ask the right questions." - Tony Shalhoub, psychiatrist in 'How Do You Know' (random but memorable quote from the Paul Rudd romcom I relented to watch with my wife recently)
Fluorescent are great in work/task areas (garage, kitchen and bath).
However, my wife hates CFLs. They are so dim. At least the first generation were. They were no were near as bright as their wattage claimed (as measured by our eyes anyway).
That's why we have regular fluorescent in garage, kitchen, etc.
I don't know if this is a consistency issue or if I just haven't paid attention to the ratings, but to say "they're too dim" overall is, I think, oversimplifying.