Last Saturday, I finally purchased my first digital video camera. It is the Canon ZR800, and I must admit, it's pretty good for its price!
Yes, the motor noise is there, but in most cases it's sort of minimal. It can easily be removed with noise reduction in some video editing software, I heard, and I tried it out with an external microphone, and that really improves the sound.
I'm able to easily capture video using the Pinnacle Moviebox Plus USB device from its DV port from the camera to the computer, with full device control on Pinnacle Studio Plus AND Adobe Premiere Elements!