An AWD wagon with a modest ride height can also tackle most unpaved drives, easements, or access roads most of the time, combining limited offroad ability, all-weather confidence, and cargo space with the handling characteristics and fuel efficiency of a car. That's how my wagon sold me on Subarus.SUVs can tackle offroad terrain just as well as trucks can if needed. Though station wagons are for people that want the handling characteristics of a car while still having cargo space similar to the other 2 vehicles.
Of course, that doesn't apply so much to performance wagons with low-profile summer tires and low ride heights. And thirsty engines.
I think it's a matter of drivers one-upping other drivers, because like you mentioned in your post, driving a tall vehicle prevents other tall vehicles from blocking your visibility.Personally though, I never understood the visibility argument. I've been in both trucks and SUVs, I never felt like I had a better view of the road than in a car.