I use a DSLR (but I'm an old SLR snob who wouldn't use a compact if you paid me to) - but the wife has a digital compact zoom.
Lens quality and macro functions are primary concerns. Megapixel rating not so much.
My DSLR is only a 6.1Mp, but I have a macro lens that focuses down to 21cm.
Also, consider a tripod (or some way of stabilising the camera). You don't want to be hand-holding it. I have two flash heads I can use (45* to either side) but other strong light sources will also do.
Hey! Where'd ... Everybody ... go?