To take the opposite end of the spectrum:
I can't comment on the "nothing fancy" requirement, but if you have an HD television, or are going to get one you should definitely go with an HD video camera. I have a Sony (they have hard drive HD ones now) and when I plug the camera into the Plasma...