The Canon S90 is very good, and the G10/G11 are very nice as well. Of course, ultimately the quality of the photos is up to you. These cameras do have a lot of options for control though, something you'll find more and more useful over time.
From what I have read the S90 and G11 have the same sensor. Could be wrong though.
I had both and both had virtually similar outstanding pictures. I would go with the s90 for portability though. The G11 has all the bells and whistles.