My experience is that Dodges aren't nearly as bad as people make them out to be. It was the about 95 - 2003 stuff where they had a terrible decade - mostly due to tranny problems in the Rams, Dakotas, and Durangos.
I had a 90 Dakota 2wd/OD auto/3.9L non-magnum that had the tranny die at 180,000 and consistantly got about 10 mpg. Other than that it was slow but bulletproof.
My friend had a 88 Dakota 2wd/AX-5/2.2L carb. It managed about 15 mpg when you could get it start. The only problem with that truck is that it was really too slow to drive in traffic. You ended up being a hazzard.
That same friend then got a 92 Dakota 2wd/OD Auto/3.9L magnum. Now that was an awesome truck. It got about 14 mpg but had more balls than alot of other stuff on the road. When he sold it, it had 215,000 miles on it and the original engine and tranny worked like new.
By brother had a 93 Dakota 4wd/AX-15/3.9L magnum. It wasn't as fast as my friends 92, but it got 14 mpg and was really reliable.
Another guy I know had a 98 2500 Ram 4x4 with an auto and 5.9L. It was slow and got 10-12 mpg. He would buy rebuilt transmissions 2 or 3 at a time as it was going through them roughly every 20,000 miles. He owned his own shop so it wasn't a big deal to put in the lift and pop a new tranny in. But other than that it was a great truck.
My uncle had a 96 1500 Ram 2wd with an auto and 318. It too struggled to get better than 12 mpg, but other than that was a fine truck. The tranny started getting goofy at about 90,000 so he sold it off before it crapped out completely.
Then my brother's brother-in-law has an 89 Ram 2500 with a CTD and the A727. It has 300 something thousand on it and still runs awesome, gets 20 mpg, and will tow anything. It has gaping holes in the floor, shakes like jackhammer, and he's replaced the tranny 3 or 4 times. Otherwise still an awesome truck.
But for a truck that you don't plan on DD, where gas mileage isn't an issue, an old Dodge with a 4-spd manual sounds like a perfectly tough, suitable truck for occasional work.