Which Video camera should I buy for our family?

I am looking for a video camera to buy for my teenage daughter (and the rest of the family) who enjoys creating movies on the computer. We had one, but there's no way to get the image onto the computer easily at home, so the new one should record to a memory card or we should be able to feed its data right into the computer. (the old one we could only do that with still shots) It also needs to have good sound quality and work well in low light conditions because I will be using it to record my partner's band's performances and we may use those for promotional purposes. Still shots are not required at all (never used it on the old camera, we've got another camera for that). It also needs to be tripod ready. Finally, it should be a good cost value because I'm not going to spend thousands of dollars on this thing. Any suggestions?

the camcorders with the build in hard drives are good. i believe jvc makes some like jvc everio-g gz-mg37us about ($500) would have been one if i didnt get my sony. i have a Sony handy cam dcr-dvd405 about ($500) which i love a lot except the minidvd format. your videos can only be 30 mins long before switching to another dvd. What kind of movies? If she enjoys making films, then get her a miniDV camera, period. If you just mean movies as in home videos, then a hard drive camera will probably be good enough, but miniDV is still preferable if you want to edit. Dont go for dvd cams at all. As for sound quality, I have a $1500 GL2, yet a $300 mic would probably have better audio. So my point is, dont look for good onboard mics, look for cams with mic ports. Also, I can safely say that all cameras being manufactured now have tripod holes, so you're good on that. I'm not too familiar with specific models (or hard drive cams for that matter), but I've heard good things about the canon elura 100, its around $400, and has a mic port, so you could probably get a $200 mic and have it come out to around $600 total; not bad considering your getting good audio and fairly decent pictures. Panasonic's pv-gs series has some 3ccd cams, the ones I would recommend are the 300, and 500, and I would recommend the 400 over any camera, but you probably wont find one, unless on ebay. However, if you do find a gs400, get it. It will be the best quality for the price. Hope this helps!