those retrofit long tube things, I wouldnt touch them with a 4 foot tube

.
they would still have the efficency issues of the original ballast, the driver inefficency, and nasty little 5mm leds probably from china, then cost a mint besides.
but the Cree 3X bulbs are sorta nice, they have handled many things the CLFs around them are dying for here, and although i got ugly bluish ones, they are brighter than both the 11 and the 14 CFL, In the same application the CFL was used. it aint cheap and it aint pretty, but it does the job.
i have a 60-80w fully dimmable LED candelabra with a "driver" if you would call it that , is more than 90% (power) efficent, by just driving 170V dc from rectification.
people fear the 170V dc , even though it is low current, but they are fine with the 1000+V ac going to a florescent tube. so that isnt likly to fly. lit lights up a whole living room to brighter than the 300w of halogen candelabra it replaced, and dims fully and mostly linear looking with a normal (but expencive) wall dimmer.
the 77 (claimed) watts of the candleabra CFLs were way dimmer than the 25W halogen (double frosted didnt help), ticked off everyone, were not dimmable, and died one by one in less than a year, after being on for average 30min a day at most. so i had to do something.
some 55 cheap luxeons wedged end to end driven low, a bit of resistance, and bridge rectifyer and a cap, and ANY configuration of lights we see today could be replaced with leds, i got a bundle of old lux 1W for $1 each.
so there are possibilities that are beyond human consumption for LED, that basically just direct drive the lot (carefully). guess it just doesnt sell drivers though
also there is the ACrichie, which you can just stuff a 110 or a 220 plug right onto the end, and jam it into a wall socket (the plug not the led board), but it has some loss in some of the added resistance to get to the 50+ gate things in a single high powered led package, and the big problem of riding the sinewave.