for dvd camcorders, i've heard good things about
DVDxDV, which converts non-commercial DVD videos into Quicktime DV files ready to be imported into iMovie or Final Cut Pro/Express. Although, I have never used it, i have heard it works well... maybe someone here can give a testimonial.