Both cameras are very popular and take excellent photos. But there are reports of certain problems with each, that you should be aware of.
I am seeing an increasing number of reports of cracked LCD screens on the Canon SD cameras (particularly the SD500). Canon has been contributing this to physical abuse (dropped camera, etc). There is also cause to believe there is a manufacturing/quality control/assembly problem.
I would say that the cause of the problem is undefined at this time.
The Sony W5/W7/P100/P150/P200 gets complaints about some blurred photos when used in low light or flash situations. This is caused by the camera selecting a slow shutter speed under those conditions. If you do not hold the camera perfectly still, the photo will be blurred due to camera movement.
There appears to be no problem with blurred photos under normal lighting conditions.
................................................
Before you make a decision, I would like to see you add the Nikon 5900/7900 to your list, if you have not considered it yet.
................................................
...
..
.
I like the larger LCD screen and AA batteries that are part of the Sony. I do not know anything about the Memory Stick. Are the Sony and Canon equal as far as quality? Customer service? I am leaning toward the Sony W5 or 7, but am just not positive. Any thoughts would be appreciated. It is time for me to make a decision. Thanks. Pat

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic