I had a couple of old Audis years ago (the 5 cyl turbos) and a Saab and liked them a lot, but parts (let alone labor) were expensive and I basically swore off Euro cars and have been getting Japanese cars since. My last 3 cars have all had great shifters, which means a lot (2007 Civic SI, the TL, and the Miata). I seriously considered a low mileage, one owner S2000 but couldn't pull the trigger - the Miata was the same price for a new car with a warranty, etc.. The S2000s are becoming collector cars anyway - I didn't want to be hesitant to drive it!
Anyway, my suggestion would always be to avoid a money pit/headache. Find a reliable, relatively cheap to run - but fun - car. I know it's FWD, but the new Civic SIs are supposed to be great - otherwise you'd have to go back a few generations and try to find a clean one. This is probably not a cheap car to run, but I've noticed that the last gen RX8s (with the funny half door) are still pretty affordable - but they get V8 mileage and apparently can have issues that cost $$ to fix. If you want a RWD go-kart as a 2nd car a used Miata checks a lot of boxes. They've made a million of them, so you're not going to pay a premium for a nice adult-owned used example, and they're reliable and cheap to run. And they encourage you to pay 100% attention when driving so you don't get "SUV'd".
some great free advice on this board - i really trust you guys for some weird reason.
I've got mechanic resources in the family, which helps a lot. Mind you, he hates anything european as well, for a lot of legit reasons but I ignore him for the most part. He refuses to work on rotary engines so no RX8 (though I drove a friend's Rx7 once and it was basically a toy, in a good way).
I tend to feel much safer in a small car, though these days almost everyone is on their phone while driving so it's more scary. Since this pandemic, i've worked from home full-time so only need a car for golf clubs, zipping around Costco, and I want my son to learn to drive a manual as well so seems like it's going to be a fun car for me. I don't care if it's a bit of a project as long as parts are readily available.
I think I prefer an old Prelude. I read they may be bringing it back but it'll hardly capture the spirit of what the original one was (and will probably be labelled an Acura or Accord eventually).
Any experience with those Chrysler-Fiat500s? I want to like them, but the emasculating Miata is not even as bad as a 500 (even the Abarth version) but I can't imagine they'd handle well. They seem so gimmicky, cheap and misplaced - like a worse version of the new Beetle. And I've read that those Fiats are so incredibly poorly built and break non-stop.
I had a BMW 3series convertible for a year or so, hate that brand and those cars now, not even sure why. I felt like an asshole in that car and maybe I was - other drivers hated me YET in every other car, never heard a peep.
Same with Mercedes - prob since my idiot neighbour has one and he hasn't figured out how to take out the garbage yet. And he can't pronounce his own dog's name - next level stupid and now I hate his damn car.
So. The short list:
Love the Prelude, hard to find.
Accord Coupe is a nice compromise - hard to find in a manual
TL - love it, but again, tough to get a manual and kinda big
stretch: S2000 but not likely worth it for price/daily driver - not interested in a museum piece.
Miata - probably best value for fun/parts/pricing - will figure out the golf clubs but workable.
Other maybes:
Toyota Celica - but kinda underpowered, hard to find as well
Supra - Fast & Furious ruined them for many, price is nuts
BMW MCoupe or Z3/4 (but hate BMW)
Audi TT seems nice but worry about reliability/oil - kinda pricey and really small.
Don't want to spend on anything expensive cars are such a waste of money