There are some in-depth threads about this, probabl worth doing the dreaded search on.
Short version:
Fluorescent is good for general illumination but only shows the *worst* marring (though it somehow works better on white paint :nixweiss ). I find it useless for swirl-spotting and I have dozens of 8' tubes in my shop (nice and bright, but I only see really *terrible* marring in this light).
Halogen is good for general illumination while polishing, shows a lot more than fluourescent.
High wattage incandescent, used in an otherwise dark room, is the *best* for seeing marring. Some of the other threads explain the science behind this ("distant point-source illumination" IIRC). Good for inspecting but not as good to work in.
Natural sunlight is good for spotting marring, especially rotary-holograms, which basically *only* show up in this light.
So I have five different light sources in my shop and I use them all on details where I'm trying to really do a good job.