I'm not an expert but the card you're looking at should fit the bill. My Sony DV cam transfers video at 200Mbps (half the speed of the card you mentioned) Max speed for FW is 800Mbps but I don't know of any consumer products using this amount of speed yet.
Camcorders need a 4pin - 6 pin cable (my Sony does anyway).
There are also 6pin - 6-pin cables for computer connections.
You might as well order a 4 - 6pin cable along with the card.
I picked up a sony branded 1metre iLink cable for €40 (about £25)
Anyway you can't go to far wrong at a tenner!
If you have more than one PC it might interest you to know you can use FireWire for networking; you just need an FW card for each PC and an FW cable. Possible speeds of up to 800Mbps!
HTH
Owen