Thoughts, considerations, recommendations?
I think the answer to auto or stick is a function of availability and mission. If your searching the recently used market, auto vs manual availability is something like auto to manual 7 to 1. In the brand new market some mfg's don't even offer a manual anymore.
I'd consider your core mission or "focus" and "operating arena" for the truck. If the focus is to have a weekend fun buggy to haul your camper and boat to lake and run around in the woods then it's probably up to your personal preference. Both will do the job and unless or personal situation allows you to deploy the fun buggy daily you may never have enough duty cycle to reach a failure rate. I personally own a 5 speed manual pickup and haul my Grandby/15 foot outboard just fine. I've also hauled the camper on a trailer behind my wife's auto equipped Expedition loaded with people over the Cascades to the coast a couple of times and it did just fine. If the focus is a fun buggy/daily driver/commuter and you have a lot of stop and go traffic it's hard to beat an auto and probably will experience longer service life of that component. If your operating arena requires a lot of pulling grades or mountainous driving I'd buy a stick. You'd be hard pressed to find log truck or cow hauler around here with an auto. We're pretty short on rock crawler types around my neck of the woods but we have a few off road racers, (think Baja 1000 type) and they are almost exclusively purpose built automatics.
Based on my experience with my place of employment's commercial fleet, unless you fall in the stop and go category or have a health issue that precludes operating a clutch buy a manual if you can find one. In a forty something vehicle fleet that ranges from 1/2 ton supervisor trucks to 80,000lb+ lowboy's and including a couple specialty 6x6 off road trucks, the transmissions rarely break. When we do have a transmission issue though, it's usually with the auto equipped trucks.
If you do go auto I'd look for a truck with the factory camper or towing package. These typically came with a heaver duty cooling system/transmission cooler.
Good luck and happy shopping.