The best place for the Reds would be Linton-on-Ouse - remote with plenty of open space around. It's not too late yet...
Leeming has to be worst location as no practices could be achieved using the main runway, which is essential for build-up with newer pilots, as the surrounding area is populated and close to the A1.
Waddo is surely too busy and the A15 will restrict display zones.
Wittering could work if the training area is shifted west towards Collyweston, mitigating impact on A1. Not perfect though.
My call - reactivate Cottesmore, joint base share with army, new hangar & facilities on old TTTE pan. Just the runway lights to put back in. Commutable from Scampton too.