What camera is good for pictures and videos and isn't super expensive?

I'm looking for a camera from Nikon or Cannon that is good for taking pictures, and shooting videos. I've thought about the Nikon d3100, but I'm still not sure. I've heard that the quality of the pictures/videos depends on the lens. What camera and lens would be good for shooting videos and doesn't cost a whole lot?

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.

If you want great pictures, either get a separate digital camera or use the one on the camcorder. The digital camera will give you better pictures than the camcorder ever can

Nikon D3100 is a phenomenal deal for non professionals, the rest of us people that want to take family and travel shots. I've owned DSLRs since 2004, starting with a Nikon D70 and then moving to D40, D200 and Canon Digital Rebel XSi 12.2 MP Digital SLR Camera with EF-S 18-55mm f/3.5-5.6 IS Lens (Black) and Canon EOS 40D 10.1MP Digital SLR Camera (Body Only). Those are all excellent cameras, but this Nikon D3100 is better than all of those in one crucial area, the area that matters: it takes excellent pictures without having to fiddle with the settings between shots.