What's your budget?
A bigger budget (>$150) will get you something easy to use like the
Canopus ADVC-55. All your audio and video inputs are right there. No RF though.
A more conservative pricepoint will get you a standard software-based capture card. The two popular chipsets are the Philips SAA713x and the Conextant 878A.
The Hauppauge PVR-150 provides even better quality than those two but AFAIK it only records to mpeg-2, which is no good for post-production if you plan on working with the captures in an editing program.
With all choices except the first one it would be ideal to feed the sound to the line in port of a dedicated sound card. And none of these options provide a spare Firewire port, have to get that card separately.