There's a few things out there but there's a FCPX plugin called Image Sharpener 2 that is quite good and inexpensive. I've used it on some old DV SD footage with nice results. You can get it through FX Factory https://fxfactory.com/info/imagesharpener/
If you want to spend several hundred dollars, you can go to Sharpen AI from Topaz. I've seen some amazing results with it in their demos. https://topazlabs.com/sharpen-ai/ They have a trial version I think.
I think there's some other products out there but those are the two best I know of personally.