Pick up just about *any* used Nikon Coolpix camera. The older 2/3mp versions must be selling for around $100 (or less?) on the used market, and they can focus within about an inch of an object. Despite having my Canon DSLR for the past two years, I've still kept my Nikon CP 990 here -- it only gets pulled out for macros, but.. WHAT MACROS! Fantastic!

Sample attached (reduced in size from the amazing original).

Cheers