If you want a fun small sports car, that is cheap to own, the Miata is probably the best one. I had a 99 and kept it for 3 years, and had very minimal trouble with it. Tires, spark plugs, and regular maintenance was about it. The radiator eventually started leaking, but I replaced that myself, and it was relatively easy.
Two caveats - they are small inside, and six footers won't fit. Second caveat - they lower the IQ's of drivers around you
Living in the big city, I had a couple people deliberately cut me off or harass me, and several times I had people pull in front of me, acting as if I wasn't there. I finally sold it after too many near misses.
If you remember the story of James Dean the actor, he was killed when a car didn't see his small silver Porsche on a remote highway. My Miata was silver, and I finally realized, small silver cars just aren't seen by people in traffic. So get a bright color, if you get a sports car.
I do miss driving down a mountain road, on a nice day, with the top down, enjoying the scenery.