I would have you consider a Chevy Colorado Crew Cab.
I have a 2006 model, it has 100,000 miles on it, I bought it new.
Mine is a Z71 but it is only 2 wheel drive, so it has the off road suspension, but without the 4x4 mechanicals, which means it weighs less, has better driving feel and gets better mileage than would a 4x4 model.
I have the 3.5l inline 5, and it has been a GREAT engine. It is peppy enough and has decent torque. The steering is nice with good feel, and the throttle tip-in is awesome.
With 4 doors and a REAL back seat, the truck can be used like a family sedan, and the back seats to fit adults comfortably. The large rear compartment also allows you to stow some gear without worrying about it getting wet etc.
The bed is a bit small, but for most people's needs it is just fine.
I get 18mpg on average, and I get 23 on the highway.
I just loaned my truck to my daughter-in-law for a couple of weeks while I was working on her old Toyota Avalon, an she fell in love with the truck (and looked cute driving it).
Towing capability is more than fine for the small utility type trailers you are thinking you will pull. One of my friends put helper springs and heavy shocks on the rear of his Colorado and then used the truck to pull his Corvette on a car trailer to auto-crosses etc.
After 100,000 miles, my truck has zero rattles or squeaks, is quiet and comfortable to drive and ride in, and still drives beautifully.
I plan on putting at least another 100k on it, and one of my friends at work recently traded his Colorado with over 170k miles and it was still running and driving fine.
I have had the full sized chevy trucks in the past - they are fine, but the economy goes way down with the larger truck.
Good luck!
best
mqqn