I'll take a chance. I have the G9 and it takes good macros, if you are careful. A steady/stable camera (small tripod?), and precise focus (auto focus doesn't work that well, so use manual focus). This is true, IMHO, for all cameras. Your depth of field is critical with macros, so these factors can be upsetting when you think you have it right.
The 3" LCD on the G9, along with the manual focus wheel are quite helpful, but still not the best option. You could also consider the A650 IS, but it is a little larger than the G9. It has the articulating LCD (2.5"), so it could provide some assistance when shooting at low height items, or in a pinch at items over your head (something on a tree perhaps). The A650 IS does not use a wheel to help in manual focus, rather the left - right push on the round selector, so it's not as precise as the G9 method. I don't own the A650 IS, but I do own the A620, and it operates the same way. The A650 IS has most of the same build of the G9 in lens, CCD, and features, but costs less.
You can also add macro lenses to either camera, but that requires a tube adapter first. This adds bulk to the camera, but also expands your options. Here's a link to a review by a pro that uses the G9. He describes how he shoots macro with it.
http://www.outbackphoto.com/CONTENT_.../index_pr.html
Here's a handheld macro shot I took recently, and had printed at 24" x 36" to hang over my fireplace in the living room;
Dennis
