Frontier S Crew Cab 4x2 SWB V6 6MT $24,300 USD
Frontier S Crew Cab 4x2 SWB V6 5AT $25,350 USD
Not too much more than retail for my 2013 V6 2WD Crew Cab. Frankly, that is a whole lot of vehicle and practical utility for ~$25k. Move 5 humans, a load in the back, and reasonable towing capacity. The big hit is fuel economy, which is similar to a full-sized pickup. The reason to go mid-sized is due to initial cost/outlay of +50% and/or size considerations.
An I-4 turbo diesel would be the bee's knees. Or would be if the EPA had not destroyed a good deal of the diesel's advantages with its strang-u-lations. Diesel power and torque delivery is just a better solution for trucks than gasoline.
Loved my last-year (1997) king cab hard body. No V6 available that year, but I really didn't need it with that good I4. I got 185k mostly trouble-free miles and 14 years out of it until another driver hit me and totaled it.
As for getting new, mine is barely broke in with 91k miles. In 3-4 years it goes to one of my kids to drive throughout HS and college.