For normal photography - yes.
Someday you will want to do something special with some of those shots you took .... way back when.
You can always make a photo smaller without much degrading of the photo.
You can not make a small photo larger without degrading the photo.
While turning some of my shots into a DVD slideshow with software that permitted zoom and pan (the Ken Burns effect). I found that an 8 megapixel photo let me zoom further into the photo without loosing quality. This adds movement to the slide show.
As Martha Stewart would say....."That's a good thing".
With higher quality televisions, and DVD players coming along, this will be even more important.
Shoot big and best quality.
.................
But........
If you are taking photos that will ONLY be used for email or posting things on eBay. I would set the camera for 640 x 480, or 800 x 600.
...
..
.
I do, I have an SD450 and I set the picture quality to Superfine and the resolution to 2592x1944.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic