The trick with fluorescent or any other lighting is to get lights that have a very high Kelvin rating, this is what will show your scratches. The color temperature of the sun can be above 6000K, incandescent bulbs can be as low as 2700K and regular fluorescent bulbs run in the 3000-3500K range. The is also the range that halogen comes in. Halogen shop work lamps are often much higher wattage and more focused than overhead fluorescent light, which is why I believe many find them superior, you're getting closer with a lot of light in the higher end of the "normal" indoor lighting spectrum.
If you look at mercury vapor lamps (the often dreaded knife show lighting), you'll see that they have a much higher kelvin rating than common home/shop lighting coming somewhere between 4000 and 6000K. Sunlight will reveal many of the same scratches that mercury vapor lamps will. It's my belief that the varied light mantra comes from trial and error without an understanding of color temperature and lighting. It works, of course, but it's not how I do it.
I just use 600W ceramic screw type bases on the ceiling - these can handle very high wattage compact fluorescent lights. These only cost 99 cents or so at the hardware store and work with a regular plastic or metal light can, so it's very cheap to install them and you can stick whatever light you have around the house in it if you run out of high quality bulbs. You can also mix your lighting up this way, trying regular incandescent bulbs, reveal bulbs, regular fluorescent, daylight etc. You can get high wattage clamp lights at Wal-Mart for $7 each which will work well for equipment/task lighting.
Do paint your shop white or put up white pegboard or something, it will make a bigger difference than you might imagine.