I have to chime in with melabonbon on the Canon Powershot S5IS. The selling point to me during the demo was the super macro function. I've recently upgraded to a DSLR and miss the macro mode of the S5, its going to take a bit of money to replace it. The Raynox DCR-250 macro lens also fits the S5.
There is a large population in the S5 group on Flickr. You could search the pool there for macro shots to get an idea of the capability (
http://flickr.com/groups/canonpowershots5is/). I would also recommend you look at the Flickr user jciv for his S5 macros with the Raynox.