We have the same use pattern - we tow a travel trailer with a 2WD pickup and the most offroad is typical backing up a wet, dirty patch with 5,000lbs hanging off the ball.
I have revo 2s and like them alot but they probably aren't ideal if you are towing alot. there's a little more tread squirm on them than with the coopers I had before, but they are quiet and dig in well and traction hasn't been an issue. The main complaint against revos tends to be poor treadlife, and towing will exacerbate that. That said, they've become my go-to tire just because I know what I'm getting with them. This is my second set.
Firestone Destination ATs always get good marks from folks that just want a good tire that wears well and does truck life well including towing. We towed with Firestone Destination LE2s and while they handled the loads well, they were no good with a load in the wet, and that doubled with gravel, dirt, sticks, and a trailer on the back.
I've heard good things about the goodyear AT - the one with kevlar. reasonably quiet, good tread blocks, but I've shied away from them due to other poor GY experiences. Cooper AT3 scored very well in an article a while ago, it'd be a good one to look at too. I had cooper RTXs. they handled the best of the bunch with or without a load, the noise was average for an AT, but they did start cupping aearly on even with good rotating.