If I was looking for a used vehicle, A V8, standard transmission , 2 door would be exactly what I would be looking for.
The manufactures have been trying to kill off the manual transmissions in pickups for some reason.
About 20 years ago my parents were told that GM (I think) would not warranty a pickup with a manual transmission for towing.
RAM was the last manufacturer to offer a manual transmission in their full sized pickups (only 2500/3500) with the Cummins Diesel, but discontinued it a couple of years ago.
Toyota may have a manual on some of their small pickups ????
I've got a 2013 RAM 3.6L with the 8 speed automatic transmission. So far it has been doing quite well. The transmission seems to slip a little when driving or backing my trailer up my paved driveway, and does better shifting to 4WD Low. However I haven't had that issue on the highway.
An annoying thing I discovered last summer when I was driving/towing up my back hill. I'd set it to 4-Low, and get a run for the hill. About halfway up the hill, I'd lose all power, and finally discovered that it had upshifted at the bottom of the hill, and couldn't downshift fast enough mid hill, nearly stalling the engine. How annoying. I wish I had the manual. I've started manually limiting it to 4-Low, first/second gears, and I seem to be fine, well, until it started raining and everything got slick.
An 8 or 10 speed manual might be nice, but would be a royal pain to shift, especially if it had two sticks like some of the big trucks.