You don't want a camera with lots of optical zoom. Zoom is for far away objects, not close up photography. I agree with Seattle_Aquarist, the best cameras for macro shots are the Canon Powershot series. I had a Canon Powershot A95 before I got my Canon 5D SLR camera and the Powershot offers the full range of manual settings and exposures that a pro camera offers, allowing you to take decent macro pictures.
A really good camera is the Canon Powershot G10. This is probably about the best non-pro camera you can get for macro. Or if you don't have the 350 bucks it costs, you could get the G9 which is nearly as good.
http://www.usa.canon.com/consumer/co...delFeaturesAct