The Nikon Coolpix "Swivel Bodied" models (Coolpix 950, 990, 995, 4500) are usually regarded as having the best "straight from the box"macro ability by professional reviewers.
They are able to "fill the frame" with something around 2/3" across with virtually no distortion (since the macro "sweet spot" is at around half zoom).
BTW, Steve Sanders (owner/editor of this site) has probably used more cameras than just about anyone (look at the number of reviews he performs).
You may want to look at some of his posts about it.
His reponse tosomeone asking about cameras with good macro ability:
Quote:
The digicams that wrote the book on macro mode are Nikon Coolpix 950, 990, 995, 4500
http://www.stevesforums.com/forums/v...amp;forum_id=9
His response to someone asking what camera was used for his product photos (since the posternoticed that they were so amazing and clear -- especially the closeups of the dials and buttons):
Quote:
I use a Coolpix 4500, before that we used a Coolpix 995, before that we used a Coolpix 990. There do have some of the best macro capability in the business.
http://www.stevesforums.com/forums/view_topic.php?id=17611&forum_id=2
Now, whether or not you need macro ability this good depends on how you plan on using the images. If for web posting only, thenmany digital cameras will work well enough (since you can simply crop the center portion of an image for web viewing).
However, if you want the "best macro", go with a swivel bodied Nikon.
Unfortunately, These models are no longer being manufactured (although, if you look around, you may be able to find the Coolpix 4500 in new condition).
Lighting and technique is probably more important than the camera you use. For one thing, uniform, diffused lighting can help to put a product in a better light (pun intended). But, you'll want to use a tripod (or a specialized equipment designed for taking macros).
Also, use of a smaller aperture (represented bya larger f/stop number) can be helpful to get the most depth of field (which can be shallow at closer ranges). So, this will require a model with the ability to control the aperture (either via Aperture Priority Mode, or Manual Exposure).
Using a smaller aperturewillrequire slower shutter speeds (again, why "hand holding" a camera for macro use is not verypractical, since a flash can cause unwanted reflections, and shutter speeds will be too slow to hand hold a camera using smaller apertures without unacceptable motion blur).
Here is a site that I've seen Steve recommend before for lighting small subjects. Note that their tutorials assume that you'll be using a Nikon Swivel Bodied model:
http://www.clouddome.com/