Honestly coming from a diesel I wouldn’t recommend this.I'm going to suggest something a bit wild here but a friend of mine went this route...
A Certified Preowned Porsche Cayenne 3.0L V6 Turbo Diesel
1) 240HP but... 406lb-ft torque
2) Has dual range transfer Case for Rock Crawling off-road capability
3) 21 city/28 hwy but he's reportedly getting 35mpg with other forum people hitting near 40mpg (supposedly)
4)Any issues are Covered under warranty (3yr-36K)... any basic wear and tear or maintenance take it to a local shop for saving.
He got it for around $35K and these Diesel engines last Forever.
tdi engines are not bulletproof and when the warranty runs out the emissions gear will cost more than the car to repair. These have multiple cats, DPF, EGR, adblue. These parts have a 10 year 120k warranty.
outside this I highly recommend this car. I have a Touareg tdi (basically the same) it’s gets low 20s in the city and high 20s on the highway.With all terrains it off roads like a beast.
it’s is very very hard to find a cayenne with low range gearing and the adjustable air suspension. Maybe 1 in 100 have the off road package.