Adobe Premiere, or Adobe Premiere Elements is top notch stuff. I've used them before and they work, but they're pricy, of course, since it's Adobe. I think it's capable of both firewire and USB transfer, though I think firewire is faster. Maybe not, I dunno. I hope this is a digi cam, btw, otherwise you'rre going to need hella more hardware. If it's a regular cam that doens't have USB or FW, you need something that has RCA (Triple head plugs) in. Premiere should be able to handle that as well, but the hardware's the issue there. Might just need a TV tuner card or something, I dunno much beyond digital import since it's been years since I've used an analog one ;P
-Karrde-