I have one of those Frontiers, with a manual transmission. Absolutely flawless drivetrain. Rust is another story. The cargo bed is full of holes and I've had to replace parts of the suspension due to rust so I'm not sure how much more life I can get out of it.

REO[1] is supposedly coming out with a basic manual truck.

Slate is another option, but in the prototype videos I've seen it looks like it has about a 4' bed. That's too small for a utility pickup truck.

[1] https://reotrucks.com/