Which Direction for Good Handling, Forgiving Z?

wheelspeed

Hi folks,

I sold my Mazda 3 in late 2019 with plans to get a sport RWD car. I loved that '09 Mazda 3 just fine for my 4.5 mile, curvey-road drive to work, except for the FWD nature. I slid it almost every day I drove it to work... sometimes a little mid-corner push, but mostly just plowing as I came out of corners with the gas on. (Had All-Season tires that leaned towards the snow-traction side (Extreme Contact DWS), so plowing and stuff was nothing scary. I'd just ease off the gas and it'd stop sliding right away. Also, these little back roads only let me get up to 40-50mph at the high end, so it's not like the car's mass was going to get away from me.) I put a stiffer RSB on the back and put decent suspension on it, which made it even more fun, but I still got tired of the FWD push and knew there was no way around that except to change cars.

Now, I mostly take a motorcycle to work on nice warm days, and have an AWD Ford Flex for bad winter days, but could use a car for non-motorcycle weather or that my wife could use if I take the Flex camping for 4 days.

I drove the convertible and soft-top Miatas and didn't like them.
Drove a '19 BRZ and didn't care for the lack of midrange.
Drove a '12 370Z and liked the seating position. I can never pick up on the finer details of a car's handling just from a test-drive through suburb traffic though. But a local one never seemed to fall into my lap.
I think BMWs took a downturn in the '00s, so am not interested in them anymore. I did enjoy about 4 old BMWs that all had LSD and I drove them through rain/snow etc. so I want to get back to that kind of RWD behavior.

When the new BRZ came out, I was set on getting one of those, but it turns out you can't get them.

Do you think the 370Z could be made into a fun car for low-speed twisties on cold days / rainy days? I believe I heard that they're not perfect stock (like no car really is), so I wonder which direction you think is better if I decide to pick up a used 370Z and have all-season tires on it?

A. Sport version manual, and then- What kind of suspension mods / what kind of cost am I looking at in order to make it a fun, forgiving car for lower-speed twisties? I think I would probably look into a square setup also.

B. Nismo version always seemed outlandishly expensive for the mods you get. But I guess most of the mods are suspension related, so do you think that's the direction I should look for a go-kart type thing that's fun and forgiving to drive with all-season tires? Please leave looks out of your mindset... I know it's blasphemy but I like the standard looks better than Nismo. I just mention that so your advice isn't swayed by "looks" or the body package. I'm just asking about handling only. Like if you really need all the Nismo stuff for lower-speed roads, or if just a few changes to a Sport model suspension would get me what I'm looking for.

P.S., if any of you here are general car fans, I'm open to other suggestions. But I think I thought of most of them...
Lotus Elise- Prices shot up recently and doesn't seem worth $45k.
Camaro SS 1LE - Still in the picture, but wife doesn't like them. I can live with that and still considering it, but kind of sucks to spend $50k and of course it'd be like a 'date-night' car and knowing my wife hates it is a bit of a downer.
Porsche Cayman- I wouldn't mind to own a Porsche once in my life, and at 52 my next car purchase might be my last chance, but really I heard the Cayman is overly capable on smaller roads and doesn't feel fun except on a track. (I worry about this with the SS 1LE also.)
Corvette - Wife loves them and is on board but I heard they're not very forgiving when you're driving fast. (?) I think it'd be a C7... but honestly not too interested in going over $50k for anything so these days, C7 might be a challenge.
'23 BRZ - I could hold off and order one, but it may cost me ~ $1,000s in rentals so my wife has a car while I take our SUV to do guy stuff on a 5-day weekend.
NOT interested in any AWD sportscars at all. NOt interested in automatics.

Sorry for the novel. I wish I knew of a good sports car forum where people just shoot the crap about things like this, but I don't.