You're lucky there, actually, since there are now so many good digital point and shoot cameras. Any of the Nikon Coolpix cameras or Canon Powershots should be more than sufficient, all of the 4/3rds models, most of the Panasonic FX and FZ series cameras... the list goes on and on. You can't go wrong if you pick a brand you trust.
More specifically, the Canon Powershot SD1300 or A3100 ($135), Panasonic Lumix DMC-Zs5 ($250), Nikon Coolpix P100 ($350), and Pentax Optio cameras ($200 or so) have excellent macro focusing.... among many others.
Keep in mind that none of the photos above were taken with the camera's macro settings; these are simply close-up range pictures, so even though it might be a good idea to pick a camera that claims a "macro" focus range, it may not be necessary.
Light and Matter Photography Community: http://www.lightandmatter.org
Log in Register
Your B&H Photo login also works for B&H Insights! After your first login you will be able to create a username.