Welcome to the forums!
If a quality capture is your goal (and why shouldn't it be?), then avoid Ion and Elgato products.
Your logical first move might be to get a decent capture card. Shouldn't set you back more than $200.
But which card should you try to procure? The answer depends on what it's going to be connected to.
A Windows PC is recommended for capturing. If not Windows XP based, then ideally Windows 7.
If it has to be a newer version of Windows, W10 is better than W11. Generally speaking, the newer the Windows version, the harder it could be to get your capture card working. You can go the AGP route if you have an older WXP based system that can be repurposed for capturing.
If you'll transfer using a newer system, go the USB route.
Any of several ATI All-in-Wonder cards (getting hard to find) would work for an AGP setup, while ATI 600 USB (or Tevion clone) / Pinnacle 510 or 710 could be a good USB option.
Try the marketplace
Get a good capture card first if you don't want to spend a lot of money upfront, and then try capturing with your existing VCR and camcorder.
Do your capturing with S-Video rather than RCA/composite video. Capture with VirtualDub
There are guides here you can follow if you get stuck setting your your workflow.
But first things first: get a good capture card out of the marketplace. You'll need it regardless of what source you're capturing from (VHS, VHS-C, Hi8, etc.)