Why no van? My vote was for an astro cargo. My mothers gets respectable mileage 18-20mpg. Its big and rides good. Has plenty of power, 6k lbs of towing.
If it has to be a truck. For a fullsize I'd go GM with any engine 5.3 or smaller. My brothers gets consistant 22-23mpg v6 5 spd stripper WT.
For a smaller truck my favorite is the 1993 or older s10 2.8v6 5spd. FE in the mid 20s good towing,etc.
After that for me its a toss up. Just about any small pickup from the 90s will be good I've seen them all with over 200k and running well with only minor repairs needed. I drove a 96 nissan for years. Best power of any 4 cyl truck. 26-27mpg hwy. I towed ALOT of stuff with this truck and it always did well boats,trailers,cars, . Although with loads over 2500lbs don't expect it to be a racehorse on the freeway.
I hate the honda ridgeline, what a joke. It doesn't do anything well. I would be extremely leary of the transmission just because its honda product.
Some pics of the death of the flash. Actually it wasn't dead it just had a rattling timing chain and was stuck in 2nd with a bad shift fork. It had 202k and very little maintenance over its life. 24mpg highway at its death wasn't bad either. It finally got hot and went dead. So we spray painted $75 on it and pushed it to the road. Someone bought it 3 days later.