Good camera for pictures/videos?

I like photography but I have a horrible camera. But I also want a camera that has good sound and takes good video's. Maybe a nikon camera or Cannon. I don't know what do you think I should get?

Cannon is one of the best brand i have used!

The Nikon D7000 takes great photos and in the hands of a decent filmer with the right lenses, can also take some awesome video. YouTube some test video of the D7000.

Nikon D3100.
Amazing.

The best still cameras are not very good video cameras, and vice versa-mainly because the requirements for still photography and video are different and conflicting. However, Canon has a reputation for still cameras that also do a very good job on video, if you must have both in one camera.

Consumer level HD camcorders have 4 problems. 1) Blurry, fuzzy, out of focus areas closely around people in videos taken by consumer level HD camcorders. 2) Any movement, even a wave or lifting an arm, while in front of a recording consumer level HD camcorder, results in screen ghosts and artifacts being left on the video track, following the movement. Makes for bad video, sports videos are unwatchable. 3) These Consumer level HD camcorders all have a habit of the transferred to computer files are something you need to convert, thus losing your HD quality, to work with your editing software. 4) Mandatory maximum record times - 1 hour, 30 minutes, 8 minutes, 3 minutes - four different times advertised as maximum record time for some consumer level HD camcorders. No event I have ever been to is that short. Either take multiple camcorders or pack up with out getting the end of the event on video.

With a MiniDV tape camcorder, record 60 or 90 minutes ( camcorder settings), 90 seconds or less to change a tape and record for 60 or 90 more and repeat till you run out of tapes.

You can get a Canon ZR960 for $250.It is a MiniDV tape camcorder, has a Mic jack. You need a firewire (IEEE1394) card ($25 to 30) for the computer and a firewire cable (less than 10) to be able to transfer video to your computer. To say this is not HD, think about this. It would cost in excess of $3500 to get a HD camcorder that could equal the video Quality of a $250 Canon MiniDV tape camcorder.