I'm convinced that I don't want to use a flash for my macro work. But I would like to use a continuos light setup that would allow for creative lighting. Polaroid makes a ring light as does Sony.
The following shot was taken using a small low power flashlight with a very diffused light. The only problem is the second tripod or a really awkward mount to the camera.