Color Rendition Index (CRI)
If you are already familiar with CRI, skip this post. Otherwise, I think you find find it helpful at this point to hear about CRI.
CRI is a way to measure how accurately a particular light shows colors. The human eye is of course closely adapted to the light of our sun. Full sunlight at noon has a CRI of 100. You can think of this as meaning that you will have 100% of your best ability to see colors and details clearly.
If you take a look at the specs for this T-8 bulb:
http://www.1000bulbs.com/F13T8/ you will see that it has a CRI of 60. This means that when working under this light you will have roughly 60% of your best ability to see color. This is not a function of how bright the light is, or how diffuse or tight of a source it is. The spectrum it produces is different from sunlight. This particular one is a "cool white" so it will show blues and greens unnaturally strongly, and reds and yellows poorly. If you work for a while in a room full of these your eye will adapt and you won't notice the distortion - until the car goes outside and you jump back up to a higher level of discrimination. So the CRI is poor, but for under two dollars a bulb most people won't notice or care.
Now take a look at these bulbs:
http://www.1000bulbs.com/F40T8/ Notice that they have CRIs in the seventies and eighties. They are closer to natural sunlight, and so will show color more accurately, but the prices jump up to two or three times as much per bulb. You can get CRIs that are up into the nineties, but they're not cheap. Quality costs. For example, this bulb:
http://www.1000bulbs.com/F20T12-Full-Spectrum-Fluorescent-Light-Bulbs/ has a CRI in the high nineties, but the bulbs run a good $8.00 apiece.
I am leaning towards the idea that you should get high CRI bulbs and light up the place quite brightly. I also feel that you could get the benefit of other detailers experience if you went around to a few shops and asked what kind of lights they use, and if the guy on the floor doesn't know, ask if you can take a look at the bulbs. Every trade has standard techniques. For example there are gadgets like this:
http://www.candlepowerforums.com/vb/showthread.php?t=192103 I assume there is a powerful bulb in there that closely matches natural light. It might be jtr1962s hand held HID spotlight. It might be that people do most of their work under a medium-good light and then use something like this to check for fine details. I don't know, but I'm sure you can find someone who does. A little research might save you a lot of fuss.