Eric,
Been thinking about the same thing as my Pathfinder gets less than 15mpg on average. Those small sport utes that you mention are not really meant for off road and don't have much room in them for carrying gear. I've been seriously considering a used Subaru Outback. My daughter has one and it has a respectable 7.3 inches of ground clearance. Even better, with the rear seats folded up and the front seats set for me (I'm 5'9"), the bed is a full foot longer than the Pathfinder. At 6 feet, I can lay down and take a nap in it if I want to. It also just as wide and only 4 inches less in height, and the 4cyl gets 30 mpg on the highway. It also goes great offroad and in the snow. It is no surprise that so many people in the midwest own them.