A bike photographer, Ray Dobbins, describes his simple, inexpensive set-up for taking clear photos with realistic color balance. His secret weapon is HALOGEN WORK LIGHTS. He uses 2, pointed at the ceiling, and apparently this sheds enough white ambient light all around to provide sharp, detailed pictures with relatively accurate color. Obviously I need some of these before I get so frustrated with all my yellow fluorescents that I launch them out the window.
The comments about this page on BoingBoing add some alternatives to the main set-up.