Tape-based miniDVs are ideal. They'll interface beautifully and require very little power to work with.
Tape-based HDV is the hi-def equivalent. These two formats were invented for editing on a computer!
AVCHD is the current wave, of course. Movie Studio HD 10 and 11 will interface with it -- but it can require a very powerful computer to move the highly compressed files around. I wouldn't try to edit it with less than a good, fast dual-core computer or ideally and i7 or quad core.