You really need to specify if you are buying petrol or diesel, which will depend on your annual mileage I would think.
There is potentially more to go wrong on a high mileage diesel car, or a low mileage one for that matter. EGR’s, DPF’s, DMF’s depending on what age you buy. Also turbo’s, intercoolers and hoses may need fixing at high mileage. To save all that gubbins you should get a naturally aspirated petrol engine for the ultimate reliability.
The odds are it will be a bit underwhelming to drive. Saying that the Honda Vtec that was in the Civic type R and S2000 was amazingly reliable and pretty powerful. Old Volvo’s go on forever.
For me, if it drives like crap I’m not going to enjoy it repair bills or not.
Get something with good history and drive as many different cars as you can, a could one will stand out.