First of all,
www.dpreview.com is a good source for information.
I use a Powershot S30. The macro isn't that great on it (it has been described as more of a close up than a true macro" which is disappointing because you can't add macro lenses to it, due to its design.
Oh, and I would tend to stay away from Sony, since they use expensive proprietary memory cards. But if you can swing it, go for it, they do make nice cameras.