>>> What I’m really after is the interface that has a scart plug at one end and a USB input to PC at the other
Aaagh! I though that I'd answered that but I now see that AB's system has done its nasty trick (that it occasionally seems to do) of not allowing multiple Amazon links in a post. Grrr!
I'll therefore repost the first part of what I actually wrote but substituting Tinyurl links in place of direct Amazon ones. That should answer your question for you:
"A Scart output is analogue. You can't just feed it 'raw' into a USB socket. You need a Scart to phono adapter
https://tinyurl.com/96arwszk
together with one of these
https://tinyurl.com/3jsd22c5
(You can ignore the reference to 'VHS' in that product description. It will work just as well with the analogue output from your DVD recorder)."
Using those two devices together should solve your problem. (To the best of my knowledge, there's no single unit that can do the job). Once you've recorded the clips onto your hard drive, you can then copy them to memory sticks.