I had one of the more recent models - I think it was a 2009 car but a 2010 model year. I ran it for about 7 years. It went everywhere I needed it to go. In the end the key is tyres so you need to look for one with a wheel size that you can get AT tyres for and I think those older ones were 16 inch wheels and you could get a reasonable selection of AT type tyres. I now have an L200 running on BFG ATs and it will not go anywhere that the X-Trail didn't also go except for a very few spots where the overhangs were a problem for the X-Trail. According to the manufacturer the L200 has only 5mm more road clearance when compared to the X-Trail. I remain convinced that the X-Trail is probably the best general purpose vehicle for someone who shots/stalks a bit and also uses it for everyday type stuff. The Australians are very keen on them and they are doing some pretty serious off road stuff with them, though they often modify them but then most dedicated off road vehicles are modified. Mine was also reliable, with only a relay replaced while I had it, but clearly as you are looking at cars well over 10 years old there are bound to be some problems.
This is the L200 in one spot that the X-Trail wouldn't go because of the front overhang, you should note that the L200 scrapes the nose getting in here as well. Again, however, common sense would solve this problem as I always have a spade in the back and it would be a simple matter just to fill in the ditch while crossing it:
On mud like this I found the X-Trail better than the L200 on the new BFGs! I didn't expect that either but, clearly, it is almost completely down to tyres:
Mine did maybe 20 - 30 miles per week off road and probably close to 12,000 miles in total in a year: