I use a dark room with dark background and the Droid on full brightness. I started out using a lighter background and flood lighting but found that dark was best (so far). I use the macro setting and a tripod to get the best picture I can but it isn't always perfect.
You can take a look at my videos to see how it looks