If you need a pocketable camera that does much better than almost all the other cameras in high ISOs and need a large aperture lens then it definitely is much better than other cameras, not to mention the manual controls.
Now you're title talks about "super-macro shots", which that's usually done with a dedicated macro lens that can do a 1:1 ratio and is more expensive than the S90 alone.
I'm looking for a digital camera that is small and powerful, and have been considering the Canon s90 primarily.
I use a DSRL camera for fun sometimes...but I need something I can carry in my pocket. I take a lot of photos that require high sensitivity up-close, like insects, plants, snakes, etc. I'd also like something that captures landscapes well.
From what I've read, the s90 is a great camera with many manual feature- but I am now wondering if it is really *that* much better than some of the competitors to justify the price?