If you want to do some reading up on what people think about cameras, the best place to do so is at
http://dpreview.com. For the Canon camera that you're considering, visit the "Canon Talk" forum --- Forums -> Canon Talk
There is a comprehensive review of the SD500
http://dpreview.com/reviews/canonsd500/.
There is a great feature there that will allow you to compare different cameras side-by-side. Its an awesome tool and pretty darned unique. Buying Guide -> Side-by-Side