Just about all small cameras do a good job with Macro Photography,
A camera with some manual controls is preferred.
Lighting is the key element.
A light box and tripod are necessary.

Here is a write-up on lighting and general Table Top Photograph,
with many examples:

http://www.shortcourses.com/tabletop/index.html

,,,