As others have mentioned, take a look at the Ford Ranger.
We have a 2012 2.2 XLT manual Double Cab and it's excellent. More than enough power to pull a horse trailer with 2 large horses so I don't see the need for the larger 3.2.
We get an average of about 27mpg. If you do longish motorway...