I have no experience with a diesel, so I can't speak a lot on that. When you mention mileage, from all I have heard the diesel does get better mpg. I guess a lot of it depends on what your needs are and what you're hauling while camping.
For me, an SUV wouldn't work. We haul firewood, river tubes and other things that I wouldn't want inside of my vehicle. Not to mention, my truck is also my hunting vehicle when camping season is over. I have the 4 door with split bench seats front & back. That gives me a seating capacity of 6 with a good bit of leg room.
How many people are you hauling? And what kind of cargo?
2005 Dodge Ram 1500 Quad Cab 5.7 HEMI
2̶0̶1̶4̶ ̶J̶a̶y̶ ̶F̶e̶a̶t̶h̶e̶r̶ ̶X̶1̶9̶H̶