I've found that "real" video cameras make for better video but it really depends on how good you want the video to be. I used a MiniDV camera in my Miata and now use a nikon point and shoot for the RX-8.
The MiniDV just looks better and I was able to use a wide angle lens.
Check out these videos:
2007 Autocross Recap