Well, most digital video cams don't come with DVI - they usually come with Firewire (IEEE 1394).
I don't think most video cards support Firewire input - however, many Sound Cards do. At least some of the SB Audigy cards do, and I'm sure others as well. Or, even easier, you can get a Firewire/USB PCI card, and many come with a front panel with both USB and Firewire hookups. Like this one:
http://www.newegg.com/app/ViewProduc...104-205&depa=0
I think that one also comes with a Firewire cable. Getting a front panel would eliminate the need for a front USB connection on the case, and it would add Firewire capability.
All of this might be silly if it's not a digital video camera, because analog camcorders usually only come with AVI and S-Video hookups. Look into what connections their camera has, and you can make a much more informed decision.
Personally, I would recommend a PCI card like the one I showed you. Then you can get a cheap case and not worry about it (as long as it has a 3.5" front bay for the front panel). And grab a cheap round cable to hook it up.
As for your video card, the 9200 should work regardless. It's a decent card, and they won't be putting too much strain on it, so they should be fine.