Only pickup I really enjoyed was my 5 speed diesel rabbit pickup
Handled good and got great mpg. Unbelievable range with a 15 gallon tank too.
Though a 4 door diesel rabbit with a trailer was far more versatile, carry the average family AND 4x8 feet+ of crap when needed, getting 50mpg on renewables.
I wonder if the truck could be made more aero than the 4 door (or even the prius with extensive mods) with a well designed openable shell, and add in some rear facing seats in the bed beside the cab. Add a mat and the dog would like it fine back there certainly.
EDIT: and/or drive under the camper a few times a year.
(though a tent is still the most efficient traveler)