As previously discussed, when evaluating artificial light, the color temp is important but even more important, is the color rendition index (CRI). Unfortunately many bulbs' packaging fails to mention the CRI - presumably because it's nothing to brag about.
Fluorescent lights are notorious for having low CRI's, although special phosphors help to raise the color rendition index. But it's still an uneven spectrum of light, typically with peaks on the green side of the spectrum for "warm white" lights. In general I've found the daylight types of CFL's to have better color rendition than the warm whites, at least when CRI is not listed. It's subjective, of course, and the daylight bulbs tend to be a bit harsh for mood lighting. Great for kitchen and desk, not so great for living room and bedroom. I've noticed that some low CRI CFL's or circular lights tend to give out what looks to me like a brownish light. And all fluorescent lights gradually deposit metal on the inside of the tubes - I assume this is electrode material (tungsten) or perhaps some of the mercury used in all fluorescent lamps to provide the metal vapor for the lighting. Some bulbs seem to gray up faster than others, but eventually I think they all do, or their electronics burns out first.
As CREE points out, CRI isn't everything about color rendition. In their literature about their TW bulbs, they point out that even well balanced LED's still have peaks that can throw things off. Their solution is to use a rare metal, neodymium, to filter out the peaks and give a better CRI.
For outdoor lighting I like the LOA Fluorex bulbs. These consume about 65 watts and are supposed to put out the light of a 300 watt incandescent. They are box-style spot lights, giving a daylight spectrum, and I've been successful pairing them with higher quality outdoor motion detectors. They certainly do light up a large area and I find them helpful to illuminate a courtyard or patio. I think their brightness tends to be good for deterring trespassers. They are approved only for outdoor use.