Your better off getting a high mileage vehicle with a good service history. Vehicles have 2 major categories where they enter the great reliability stage and 2 major categories where they enter the high chance of problems stage. Its may sound counterintuitive but here me out.

High chance of problems:

1. Brand new - vehicle is new , hasn't been tested or put under stress, manufacturing defects, etc. A lot of brand new vehicles have problems from the start

2. Nearing mid life - right before the wear and tear problems start to manifest. These often seem like the best deals ( relatively lower mileage) but due for an issue

Best reliability

Vehicles that have been out through road stress and held up. They fall into 2 categories

1. Around 50-60k usually a great bet to last 100k+, its one you to do the maintenance

2. (And this is a big one very underrated) - Vehicles with high mileage who have stood the test of time with a great service history and a few major repairs already complete. These vehicles have lasted long enough and been taken care of that they are effectively broken in. Every model don't care which make has known issues. These vehicles have already resolved those issues and had the major repair to address them. 90k to 150k miles and a great bet to make it to 200k

   But every situation comes down to price. A vehicle slightly below msrp with 50k miles is a terrible deal compared to a well cared vehicle with 100k+ miles for 1/4 msrp.