all you need is a camera that is capable of doing low-distortion (or easily correctable) 1:1. some p&s compacts can do this, every dslr and mirrorless cable is basically capable at this point with a true, fixed-focal length macro lens. for our purposes, you want something between 60mm and 135mm (35mm equivalent focal length) as well as a sturdy tripod. lighting and stability are really the trick. if you don't have enough light, you'll need longer shutters; our subjects don't move, so this is generally ok, but you need to keep the camera very still during that long exposure, so you need a sturdier tripod. if you get a dedicated macro flat (see: nikon r1c1 or equivalent), you can get away with less tripod.
personally, i go with fixed lighting (some desk lamps with big _matching_ ccfls in them) and a cheap sturdy (read: HEAVY) amvona (ie, knockoff) tripod off of ebay/amazon. the camera doesn't matter so much, because everything is stable. a p&s will perform about as well as a huge sensor dslr, as long as you have a good lens on it.