Anything with a manual transmission. A late nineties Toyota pick up truck is a great option; very reliable, decent off road, easy to work on and manual transmission option.
I believe a manual transmission is essential for kids to learn on, especially
in today's connected world. Kids who learn to drive a manual learn to engage with the vehicle and have a better understanding of the machine which they will take with them to all future cars. It's also much harder for them to text while driving in a car with minimal automation.
I fly with young kids who have learned to fly in modern planes with auto throttle, high level automation and EFIS and it has not done them any favours. When you learn to fly or drive in a simple machine, where you control the inputs, having a machine with automaton later in life is a very helpful tool. When you learn from the start to operate a machine loaded with automaton, you are dependent on the automation; it's no longer helpful, it's essential.
Granted, the skill of diving a manual is no longer needed in today's world (at least in America), but engaging with a machine and understanding it's reactions to subtle inputs and changes is.
Ford F150 had the manual until about 2006 and Chevy was similar. Toyota still sells a manual Tacoma and Nissan offered the manual in the US until just a few years ago. A pickup also limits the number of kids who can ride with your son at any given time (not a bad thing for teenagers).
I'd also look at a 90s era TJ manual transmission, though they are starting to soar in price. Easy to work on, fun to drive and no shortage of parts.
Given you live in the rust belt, look online for cars out west. Buy a clean one and make a road trip out of it with your boy. By the time you're back in Ohio he'll have the clutch down, a great memory and a bond with the car.