For an old 6cyl mid size pickup, I wouldn't go any bigger than a popup tent camper or one of those small r pod type campers.
Even at that, the health and upkeep and suitability for running your vehicle at its limits can be pretty subjective. Is it a low 70kmi, cherry, well maintained like newish 2001 or 150-200kmi daily driver that gets repairs as needed and still happens to be on the road save for what has rusted off?
The upside is the old Dakotas drivetrain is basically a 1/2 ton in a smaller package. That said, Dodge had about the worst auto transmissions of the era and the 3.9 is no powerhouse. I had 4 different Dodge 1500s from 95-01 models and while they served me well, the transmission was nothing to rave about. I only did light towing and only one of them I kept over 100kmi.
2016 Ram 2500, MotorOps.ca EFIlive tuned, 5โ turbo back, 6" lift on 37s
2017 Heartland Torque T29 - Sold.
Couple of Arctic Fox TCs - Sold