I use halogen shop lights above for their light output, color, and dispersion, but they get hot. They resemble the florescent fixtures but have halogen bulbs.
I think the most critical thing is to have light come from both the top and the side(s). You can't see the details of a particular piece properly unless it's lit from two or more directions, which more closely resembles natural daylight. Incandescent goose-neck lamps placed here and there will really help out.