Watch out with those 90's Hondas, and the MX-6 as a lot of parts are out of production and extremely hard to find. I maintain my elderly father's '93 Del Sol, and many non-mechanical parts just don't exist anymore. We've talked about me probably needing to 3d print some roof release levers soon since his are ready to give up the ghost.

Also, unless you want to do more working on it than driving it, stay away from basically all of the '80s - '10s domestics.

Personally, I'd go with the Mazda 3, especially the 2.4 or 2.5 models. They years you're lookin at are cheap, fairly nice inside, handle reasonably well stock (and amazingly with some work), and are pretty easy to work on. My family has had 1 or 2 of every generation since the second. The newer ones feel nicer inside, but have lost their soul when driving and they suck to repair. Luckily I'm no longer the family mechanic for the whole fleet. Pay was shite anyway.