I've owned both stick shifts and autos since the 80s. Both have their benefits at times.
However, the NEW transmission in the 2nd generation Xterra is nothing like the previous models. It's always in the right gear, VERY quick and smooth. Beefed up 350Z tranny.
With this much power, having a stick buys you very little in performance, or off-road ability. For CONTROLLED off-road power, it's hard to improve on an auto.
I use my Xterra for towing. Not many here tow close to the 5000 lb limit, as I do. Torque multiplication is a big deal, and it really makes taking off from a dead stop easy without wearing out a clutch. Ditto when backing a trailer into sandy campsite (trailer doesn't want to roll).
On an underpowered vehicle, a stick is a better choice usually. But the new Xterra has plenty of motor and the auto transmission is a piece of art.
Drive whatcha want, but unless you've driven the 2nd gen Xterra with an auto, you have no idea what you're missing. See ya on the boat ramps, and in heavy traffic. Been there, done that.