The limitation for any truck is the tires. With SRW the maxium load capacity for tires that fit on stock rim sizes are 3750 lbs. or 7500 lbs. for the rear axle less the 2700-3000 lbs. of the truck, leaving a maximum of roughly 4,000 lbs. for the camper and the tongue weight of the trailer.
If you want to have up to 500 lbs. of tongue weight that leaves 3500 for the camper and in reality that means a 2500 lb. camper with 1000 lbs. of gear.
With a DRW the rear axle weight is carried by 4 tires and you get roughly a 60% gain in load capacity while staying with stock rims and tires. Downsides are a 18" wider truck and having to keep four tires properly inflated and having 6 tires to replace when they wear out and tire rotation is more of a chore with a DRW truck. There is also a lot more flexing of the frame with the added leverage of the outer wheels and so more need for a rear anti-sway bar and other modifications to counteract this as much as possible.
There are campers with slides that would be light enough for a SRW truck with the right tires. Lance makes at least 4 models that are under 3,000 lbs. dry weight. Plan on upgrading the tires and the shocks regardless of the truck you buy.
Had I gone with a DRW truck it would have had to be a special order truck and I would have paid at a minimum an extra $6,000 for the truck and probably an extra $8-10k.