This is the card I use for console capture and use a second one for my camera.
Plugged it in, opened OBS, added the source and it just works.
It really depends on how deep you want to get into it. The basic composite/S-Video capture devices on Amazon/eBay/AliExpress do work if you want something really cheap. Combine that with a distribution amp so you can play on a TV while you capture. Or if you want a higher-end setup, a RetroTINK-5X plus a component video cable and an HDMI capture device will get you the best possible quality from original hardware.
Set up I use. The splitter strips hdcp from hdmi for game capture/streaming.