I'm not a photographer nor do I take much interest in it, but a few years ago when I got my point and shoot Ricoh Caplio G3, I read a review on it and apparently it had one of the best macro zooms on the market (for a basic digital camera).
This is a close up picture of a little mains powered rock garden that was on the desk at work, the day I got the camera