I rarely buy cars

I have a 1990 Honda that for the past year has started giving me all
kinds of mechancial issues. From the small, like a dead power antenna,
to a master cylinder, a $300 cooling fan, dead A/C, ABS pressurization
problems, and now possibly timing belt tensioner issues. I bought this
new, which is why I say I rarely buy cars (only the second car I've
owned in 30 years, though I also own a truck).

What does this have to do with this board? Do I want to keep the Honda
and add more money into it? Good questions; I've been toying with the
thought of a low mileage Miata. I've never driven one, though would
love to find a place that rents them (in the San Francisco area). It
would be more interesting than a vulture/dealer salesman along for the
ride.

So I've started searching info. I see people favoring NA over NB,
though my first inclination is a recent model. I have over 140k miles
on the Honda, why get into another high mileage car? Any words of
wisdom/encouragement over the 2001-2003 models? It may be a few months
before I could seriously make the plunge, but it gives me a lot of
time to research. The Honda dealer hated me back when I bought that
because I fought a well deserved price for new after careful research,
though today's prices make a $23K- $28K car too rich for my meager
blood.

What's the word, sports enthusiasts? Is it a car worth seeking out? Of
course on this board what answer would I expect? *

TIA