If you need to finance then deals for new are a lot better, partly due to lower interest rates, partly due to VW “supporting” new sales with finance-based offers (eg. £2000 deposit contribution, etc).
In theory there are loads of earlier cars coming off their 2 year leases and some think there’ll be a flood of cars on the market pushing down used prices. Not a lot of evidence of that just yet.
Cheapest mk7 R on autotrader is £22k – you’ll pay a little more at a VW dealer. Standard VW used finance is at 10.9%.
A brand new one via drivethedeal is £25192 (and another £500 off “loyalty discount” you have a VW in the family), finance at 5.4%, 2 years/20k miles servicing for £149, etc. You’d be mental to buy the used one.
Leasing is worth it though if the deals are good – to balance out your “horror stories” I’m on my second now, first went back 6 months ago, no issues at all. It’s cheap hassle-free motoring if the way of doing it works for you.