Honda CRX HF!!! Oh, wait
The Accord we're comparing gets 18/26mpg.
You don't need a truck or SUV to drive on "mountain or dirt roads" unless you're going on really remote two-track logging roads. A FWD car or minivan will do just fine. It's also unlikely that the trucks you listed will get any better fuel economy than your Accord.
I'll recommend a Mk4 VW Jetta TDI Wagon (31/39mpg) or B5/B5.5 Passat TDI Wagon (23/34mpg). My dad has a B5.5 Passat Wagon and although it's not a diesel, it can carry a ton of stuff. The seats are very comfortable and supportive for long trips. You can lay out a sleeping bag along one side and have your cargo on the other side. Only snag is that as far as I can tell, TDI Passats were not offered here with manual transmissions.
If you get a VW, make sure it's been well taken care of. My dad got a two year old CPO and it has been very good to him so far.