There still are very few lamps and fixtures that take advantage of the small flourescent "tubes". I see some recessed fixtures in commercial buildings but "civilians" seem to be expected to screw in a CF.
That said, I use there where I can.
I wait with bated breath the arrival of "next generation" of LED lamps.
Present generation are just UV LEDS with flourescent compounds added. Their base efficiency is about the same as flourescent technology. (As an aside, high pressure Mercury and Sodium vapor lights are more efficent the flourescent simply because the internal arc produces visible light.) To could would be a mix of "pure" colors to produce a pleasing light.
The second problem is that "they" only use resistors to limit the current the LED draws. The "electronics" of the ones I have see are some filter caps, some diodes, and a current limiting resister.
But if "they" solve those problems, the LEDs will driving the CFs out of the market within a year. Yeah, their potential is SO much better.