The 2nd hand car market is nuts at the moment, and prices aren't set to drop in the short term, due to knock on effects caused by the semiconductor shortage. How long this will last for is uncertain but new cars have dried up and this is affecting all manufacturers from what I can tell. I've heard that it's not in the motor trades interests for the prices to suddenly drop off a cliff and supply will be restricted to keep prices high, but that could just be nonsense.
Who knows, I just sold my Mercedes for decent money to a dealer, who will in turn resale it for even more. I've also probably paid over the odds for a low mileage Audi A8 which isn't ideal, but I needed a replacement and everything that caught my eye was overpriced in my opinion. I was after a cheaper car but struggled to find anything decent for vaguely sensible money. A couple of nice cars that weren't got snapped up straight away. People are trying to sell cat C/D/N/S cars for what the equivalent straight cars were going for a while back, and acting like they're bargains.
I think your idea re the lease for a SUV might not be a bad idea at the moment, although the days of crazy cheap leases (Golf R's for £300 for example) seem well and truly over as you say.
One thing that I did notice though when looking for a 2nd hand car was how few were privately advertised. Not that long back I would always buy privately and there was a good selection of cars offered up on Autotrader by private buyers. Now, with the cars I've been looking at (Audi's, BMW's and Merc's) 8-9 out of 10 cars for sale are from traders.
One of my best friends swears by bangernomics, as the best and cheapest way of motoring but I tried that a while back with a cheap Fiesta that I bought from here to run around as a stop gap, and that ended up costing me 50% of the purchase price when the HG failed in spectacular fashion so that's not for me.
Saying that, there's a lovely old RR that's come up for sale on here, I remember when they were launched in the early 2000's and I absolutely loved them. It's got me doing man maths and trying to justify having it, the A8 and the GT86. Whoever buys it could probably keep it for a year or 2 and provided nothing went wrong get most if not all of their money back. That's what I'm currently telling myself anyway. I need a car for tip runs etc.
Good luck whatever you choose to do.