hi tom
i have the Canon S5IS. it's a decent camera, but i recently bought one that is waaay better. and takes much better macro shots!
i went with the Canon A650IS. it is smaller than the S5IS, but has 12.1 mega pixels. also takes AMAZING macro shots from within 1cm!! you can get the lens right up on the thing and it still takes crystal clear pictures! it even has an "aquarium" setting and underwater setting. not to mention numerous others. even a "kids and pets" setting. makes setting things up REALLY easy.
once i switched cameras i had people asking what camera i was using and started getting nominations for picture of the month (on other sites...lol). im not a great photographer, but this camera can make it seem that way.lol.
