Being that I am a Nikon guy, it looks like the Coolpix P100 would fit the bill for a macro camera for the masses. Focuses down to 4" in macro mode and even closer if you go wide angle and has manual focus. The usual VR stuff, ISO 1600, various shooting modes for dummies ect., ect. that all the P&S pretty much have.
The one thing that it does not have is the ability to save RAW image files. If you need idiot mode, then you probably don't need RAW, which requires post processing the images.
Canon, Olympus, Pentax & Panasonic/Leica each probably have a very similar camera with a different name if you prefer.