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.