I wouldn't recommend using USB for capturing video. The USB ports on video cameras are designed more for transferring still captures and using the camera as a webcam. When I first started working with video as a hobby I tried the USB port and it gave me nothing but trouble. Though if you can make it work, then that's all that matters.
I worked at a community tv station for a while and we used an older version of the Pinnacle Moviebox. It did the trick for us so if anyone else has any experience to the contrary please chime in.
Also, if your cameras have AV/DV pass through, and you can capture from the cameras, then you may not even need additional hardware. If your cameras are capable of AV/DV passthrough, you simply turn it on in the cameras menus, hook the AV cables up to the outputs on your VHS deck, put your camera in VCR mode, and hook your camera up to the computer as normal. Your computer will then capture whatever is on your VCR.
When you turn the AV/DV passthrough on it's essentially telling the camera to take whatever is coming in through the AV cables, and send it out the DV end. The down side is that unfortunately, not all cameras are capable of doing this.
The Roxio Creator kit looks like a decent option though. Having never used it I obviously can't say anything about it but it certainly looks like it would do the job.