The one camera I read that takes DV-quality movies is the Canon Powershot S1 IS. It can record that quality of video footage until there is no more room to record video on on the memory card, which in this case, is CompactFlash.
I'm trying to find a good camera to get the best video capture on it. I don't want to spend more than $400 on it though. I hope to take some good pictures, but dont want to spend more money on a video camera too. Any suggestions?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic