I've still got a Formac Studio DV which is the perfect device for doing this as well. It's got S-Video and Composite inputs, a Firewire connection for video, and doesn't require any drivers for normal use. I think it's even powered by the FW bus. (It also has a built-in TV tuner, but that required special software. I'd rather use my HDHomeRun for grabbing OTA stuff these days.)

I think I bought all of this back in the mid-2000s when I was thinking of digitizing some video, but the it never happened. All my tests of it went great, though.

Old 2002 overview of the device: https://www.synchrotech.com/support/fomac-notes.html