My suggestion is to use hardware to capture the highest quality clip as possible in the same resolution as the original. Then use software to upscale.
I just finished a job that had a similar objective. I had a 320×240 avi file from a surveillance camera that needed to be upscaled for use in a legal matter. It didn’t involve hardware, but the upscaling was with software.
I used Shutter Encoder to convert the avi file to ProRes 422 in the same resolution. In FCPX I improved the exposure then exported the result as ProRes 422 in the same resolution.
My final step was to use Topaz Labs’ Video Enhance AI to upscale 400%. It took an M1 Mac Mini over 5 hours to render an almost 19-minute clip. The result looked considerably better than the original.
Video Enhance AI is an incredible app. You can find it at topazlabs dot com. They have a fully function trial so you can test how it’d work for you.
I have no connection with Topaz Labs other than being an extremely happy customer. I own and use many of their amazing products.