I've seen this question before on CPF, but still, it's always interesting. Seems like there's still a long way to go up.
It's interesting that compact fluorescent bulbs have much lower efficiency than the big shop tubes. Still, I dislike them all I can't wait for the day that those flickering, mercury-filled monsters get killed by LEDs.
The more efficient tubes and CFLs for that matter don't flicker, since are run by electronic ballast that switches the current at 20kHz (absolutely undetectable), rather than inefficient magnetic ballasts. The difference between the two is huge -- we just replaced the shoplight in our garage from an old 2x40W T12 system, altogether putting out something like 60 lumens per watt, with an inefficient reflector, CRI of around 60, and noticeable flicker. Now we have an electronic T8 fixture with a much more efficient reflector, 2x32W power consumption, and 86 CRI. Probably less mercury in the modern tubes by a factor of more than ten. It made a night and day difference (about double the light, much nicer light quality, no more irritating flicker), and since then we've been putting in those fixtures in other rooms as well. In one room, we replaced a 4x50W track light system with the T8s in an open fixture -- about double the light from a third the power, and no more irritating shadows cast all over the place.
The CFLs give up efficiency because the self-contained ballasts are cheap/inefficient compared to good external ballasts. Also, the coiled shape is inefficient for distributing the light as a lot tends to bounce back into the tubes, or into the base. Finally, the ones that are desigend to be incandescent "look alikes" at 2700k are all terrible in my opinion, they sacrifice a lot of color rendering to get that style -- going up to 3500K (similar look to filtered incandescent) is much better.
Also, in a technical sense, white LEDs actually
are fluorescent lights -- they use a phosphor to convert blue light into other colors. Since they are point-sources though, they can work in a lot of places that fluorescent can't -- such as if you want spotlighting, or low-lighting (fluorescent works best for bright area lighting). They can also be dimmed and cycled on and off without affecting lifespan -- in fact efficiency will generally improve when the lamp is dimmed.