Here are my thoughts on it. We have a 2016 Cayenne Base with the 3.6l engine. Bought it used with 15k miles on it. Just over 40% off MSRP. Overall we really love it. We have done a fair amount of mods to it.
- We put a 2" lift on it. This gives us nearly a full 11" of clearance. Not bad at all.
- Added a Yakima roof basket that carries a full size spare. Room for more.
- 4 5" PIAA LED off road lamps that are controlled by a Blazer bluetooth controller (nothing hardwired into the cab).
- Upgraded the tires to the General Grappler AT3 all terrains. Same rims.
- Front facing dash cam.
Gas mileage is very good but we've lost a couple mpg's with the lift and the roof rack - to be expected. We get about 22 combined now. We also tow a Taxa Cricket camping trailer with no issues at all. We get about 15 combined when towing the 3500 pound trailer.
The downside is the dealers charge an absolute fortune for service and service intervals are more frequent than domestics. If you do oil changes yourself you will need to buy a Porsche compatible ODBII scanner because you need one to reset the maintenance light. The cost of the parts is about $100 and the scanner is between $200 and $300 but all in it's still way cheaper than the dealer and you own the scanner. Fortunately we found a good Euro garage near us and we take it to them. About half the price of the dealer.
Would we buy again? We're on the fence. We love the car and you cannot beat the ride quality. There are limitations. Not the largest interior. The back seats do not fold all the way down which limits storage for camping. Oil changes are 10K or 1 year whichever comes first but are easy to do yourself. For us, reliability has not been an issue and the gas mileage is great...without the mods

. Tows 7600 pound which is double that of a Wrangler. Doing what we do and what we plan to do, which is more backcountry travel, I think I would choose a Ford Ranger with the FX4 package. Certainly not as refined but much better for us when considering the overall needs. Cargo, reliable, good fuel economy (for a truck) and really inexpensive long term costs. However, we get the best looks because you just don't see many off road Cayennes and that's pretty cool.
If you do go the Cayenne route I would definitely try to find one with the air suspension. That way you won't have to get a lift.
Hope this give you some insight and if you have any specific questions, feel free to reach out.