All good points, save for the resale value comment and ride.
If one hasn’t noticed, short bed trucks are probably more numerous than long bed. The demand is the same for both. Not an economic decision factor.
And ride.... how long of a wheelbase do you need? Today’s ccsb trucks are longer than pretty much every truck from 20 years ago when most were single or ext cab. Plus, if your camper is taking significant weight off the front axle , you’re doing it wrong. I haul the biggest heaviest camper you can stuff in a short bed, with basically zero regard to what we pack in it or weight distribution and pre trip it puts a little weight on the front axle. Post trip and towing it takes some off and there’s not a lick of difference in handling. If anything matching the trailer to the back makes it handle better in turns and wind, which is strange but the tongue weight seems to stabilize more.
Bottom line, one can be super finicky about all this stuff or you can load your camper and go camping. Take your pick.