Have a look at this site for camera reviews, I found it extremely helpful when I was buying mine.
Steve's Camera Reviews
I recently bought a Nikon Coolpix5700 via the internet for about US$700 from some place in New York. I am very happy with it, the macro capabilities are excellent, however it is a bit on the expensive side.
Personally I have an aversion to Canon products but I must admit that Tim, the bee guy, has posted some great pics that he takes with his G3 and that and the Fujifinepix S7000 have similar specs to the Coolpix5700 and so they were the other two that I looked at when considering getting one. If you want big, high res pics (at max resolution the pics from my Coolpix are TIF format and 14MB each!) but don't want to pay for a full on SLR the one of the one's that I mention above would be ideal.