If you have such kind of camper, you look for other places than you would look for with a smaller car. There are places were you cannot go to with a large truck, but with a smaller one, and vice-versa.
There so many great places on earth for both types of car, so you wouldn't be able to visit them all during your lifetime. So it really depends on your personal taste, what vehicle you choose.
Last year we visited Ireland with lots of very narrow roads, just as wide as our truck, and had a great time. In the last 6 year we had to use alternate routes because of height only a few times.
There is one large drawback with such kind of off-road campers:
When they get stuck, then on locations other kind of vehicles often are not able to reach. This could take a lot of effort to get out of the mess.
