My primary camera is a Casio Exilim 8mpx, but my backup is a Vivitar 5mpx (I think). Both are just point-and-shoot cameras. What I like about the Casio is that it allows me to turn off the flash in macro mode (closeup). For some reason the Vivitar forces the flash.

I still remember an old film camera I got for $15 (Fuji, I think) that had a macro mode. Just a manual switch that put a plastic lens over the regular lens. Too bad I don't have any of the picts from those days (I was doing mostly Star Trek micro machines back then).