Probably a pickup right, OP? Unless you are hauling substantial items on a somewhat regular basis. Even if you're only hauling snowmobiles, sm fishing boats, river/float boats -- all of those are easily handled by pickups.
The obvious solution would be a Toyota. I had amazing luck with mine and it served me incredibly well for bad weather, off-road, and long drives. I eventually sold it to get something more economical (Subaru wagon) for traveling back and forth to university. I miss the hell out of that truck and wish I never did it though sometimes! But, I do still see it driving around from time to time, that's nearly 20 years that thing has been on the road.
If you don't want to be on the Toyota bandwagon I would suggest an S-10 (particularly the ZR-2 editions) or Ford Rangers. You'll get the best mpg with a Toyota (but not by a longshot).
With older models you may be inheriting frame or body rot, but it really will depend on how much money you want to spend.