It depends what you want to do with the pictures.
Are you just going to print out regular 4X6 or 5X7 prints? Then you really dont need above 5 or 6 MPs.
But if you plan to do a lot of editing, cropping, blowing up, etc... you would want to go for something over 10.
I dont know a lot about the Canon camera though.