Well, you really haven't answered the question of what you are willing to pay for the camera. All these canon "is the best" is just fanboyism. If Canon really is the best, all other's will cease to exist. There are other's such as Sony, Casio, Panasonic, Leica, Nikon, Olympus, the list goes on.
To help you out you have to give us a run-down of what you really need it for. Such as outdoor pics, families, vacations, etc. Portability? Size? The quality of the video is really dependent on you yourself because if you dont know how to take pictures, you will not get great pictures even if you have an SLR.