The price on the G-Wagons is steep, but you might want to recheck the "depreciating asset" part. If I had bought a 2004 or 05 G-Wagon when I bought my Jeep back in 2013, I would likely be able to sell it at a profit now. I recall at some point in the late oughts the '02 and '03 models were selling in the low $20k range, but now they are up in the $30s. Yeah, not like a house (my house has nearly doubled in value since I bought in '12), but damn good for a car.
It seems they have plateaued over the last few years, though. I looked at them again when I bought my LR4 in 2016. While my LR4 has suffered the standard Land Rover depreciation, the G-500's have maintained their price without any depreciation at all. A good '04-'05 was in the low $40s then, as it is now.
Time will tell if the subtle redesign will have the older ones undergo a more standard depreciation. I think a lot of their price hinged on the fact that they looked identical to a $130k vehicle to an untrained eye. Now that the newer ones are slightly different, the older ones may look dated and lose their cachet to some people.
To be honest, though, my only reservation with them is their height, which I believe is even taller than an LR4 when stock. As it is, I have to lower my LR4 to just barely fit into my parking garage at work. If I got something taller, I'd have to park in a different garage and walk.
The off-road tank part is what's so appealing to me. If I didn't care about off-road ability, I'd buy an E-Class.