It's a very good question and very well put, writing a lot of people similar confusion in words. I have advised plenty of my colleague on this exact issue.
To start with, I have been driving for last 15 years in Dubai and 10 years in offroad. Best advice is to keep the separate car for offroad for the endless reasons, (too long to list here). However, if as a beginner you still wish to have one ride fits all need, then you can choose any American, UK or Japanese cars (plenty choices), but when you consider 5-10 years of age used car then the only choice you have is Japanese folks per below list of order:
Prado (AWESOME)
Xterra (AMAZING)
Pajero (3.8 - Good, 3.5 - OK, 3.0 - NO)
Pathfinder - (Post 2006 shape - NOOOOOO)
The only American ride after 5 years of age can still ride good in sand is Jeep Wrangler or may be cherokee (not grand cherokee). These cherokee and Grand were awesome prior to 2004 shape, but hard to get one clean now, which has not been abused already.
Ford explorer - NO
Ford explorer - sport trac truck - Yes (with 2 inch lift)
F-150 trucks - Yes, but expensive in maintenance
Overall Japanese are more reliable and maintenance friendly that's why people choose them as a first choice especially in offroad.