I have 2 twin 80W (the 8" tubes) flourescent lights in the shop. This is a lot of light! I use a fourescent trouble light as well, too many bulbs blown to like the incandescent type - even the "super tough" bulbs are just a bit less super fragile. I alwys liked the super-bright light they give for five minutes after a slight drop... grrrr...
Anyway the flourescent works fine for me and it's paid for...
I have a LED battery one in my work toolkit: I work in cinema system servicing so I'm always working in dark places. It is fine and I like not needing to find a plug and having a cord snagging on things. Not as bright as the flourescent though, and of course there's no AC socket on it for a soldering iron or whatever and using rechargable batteries takes the ridiculous cost of duracells off my budget. Probaly newer LED ones are a lot brighter - all LED stuff has improved a huge amount in the last few years.
I carry a 2AA LED Maglite. It's the best flashlight I've ever had except for its low battery trick: instead of going dim they just go out. Suddenly. This is no fun at the top of a cinema screen frame with a tricky climb down made much trickier in darkness. I also carry a lighter - non smoker - for emergency light as well as a heat source for heatshrink tube.