I have a Nikon CoolPix 995 which is considered old now (by 2 generations). I paid about $600 for it then, I'm sure you can find it for under $400 now. At least on ----.
This camera is known for its macro abilities out of the box. Check out the image in my starfish post...
https://forums.saltwaterfish.com/t/126271/put-yourself-together-man
Here are some more images I've taken (non aquatic) if youre interested...
http://spline9.deviantart.com/gallery/
Its been a while since I posted anything there... Almost forgot about it. Heh.
I did some serious research before buying my camera. The Canon mentioned above was one of the contenders as well as the Sony DSC-F707. This was like 3 years ago, though. Here are a few of the sites I scoured before making my purchase...
http://www.dpreview.com/
http://www.steves-digicams.com/
http://www.imaging-resource.com/
http://www.dcresource.com/
I sacrificed size over features and went with the CP995 for several reasons.
1. The quality of Nikon products.
2. How popular the camera was at the time (was quite common and for good reason).
3. Full manual control.
4. The number of accessories available. Aside from lenses, there are other things like underwater housings.
5. Battery life.
6. Its macro abilities!
Just make sure you know what you need the camera to do and what you expect out of it. The review sites mentioned above are an invaluable resource for stuff like this. They point out a cameras strengths and flaws and show you how and why.
My biggest fear is buying an expensive piece of equipment and later realizing
"Doh, I wish it could do stuff like that other model does..." or
"Doh, I wish I knew I couldve gotten it cheaper at that other place." or
"Doh, had I known about these drawbacks..."
If you compromise, you might subject yourself to these types of griefs.
Good luck!