Usually, CFLs (or generally, all lights) will have a CRI (Colour Rendition Index) printed somewhere. You will absolutely need to get the highest CRI available if you're interested in good colour reproduction. You probably won't find a CRI of 90 or more in CFLs, but at least T8 fluorescent tubes with good CRI are readily available and don't cost an arm and a leg (that is, they're about twice to thrice the price of standard T8 tubes, but they're still reasonably inexpensive). The situation is a bit worse with T5 tubes, but improving.
I changed my lighting to a couple of 965 (i.e. 6500 K, CRI > 90) tubes and really can't complain. Of course, you'll have to like blueish-white sunlight or else it'll drive you nuts, but the real trick with high colour temperature is decent light intensity. Dim daylight just doesn't work and feels really nasty.
I've got an odd 865 T5 tube somewhere because I couldn't find an available 965 type, and the difference in colours is stunning. Some colours really do look slightly off, but it should nonetheless work quite well in areas where you just need light and not really good colour rendition.
The problem I've found with commercial LED lamps is that they're crap. Almost all of them have horrible cooling design, which will make them overheat and dim. I've seen quite a few supposedly long-lasting LED light strips with partially dimmer LEDs, so I don't quite think we're there yet when it comes to LED lighting. Sure, you can get some really nice high-power LEDs, but cooling the stuff is important as well and that's where the problems begin.