You were asking for comparisons, and I'd concur with what others have said regarding Cayman vs Emira (sport suspension)... or Evora, of which I also had two; a 2014 S and a 2020 GT. In the Cayman, I had a 987.1 S, 981 S, and 718 S. I would add a couple of things to the above:
I felt the turn-in on the 981 was my favorite of all of them, Emira and Evoras included. The 981 also sounded WAY better, with that era's signature high RPM wailing. But the Emira turn in is very very very good, everything is quick and sharp, I felt significantly more engaging than 718 and 911. Whether the "analogue" thing means anything to you is for you to decide, but there's definitely more communication in the steering. The Emira doesn't sound as good. The engine has a little more grunt, but it's not nearly as "slick" as the Porsche (no surprise). It's a decent powerplant though, and overall I find everything else about the Emira more engaging/enjoyable. You get to shift more frequently due to the ratios, shifting is a bit more clunky/chunky (I happen to like the chunky-ness). Just sitting in the car is very different... uncomfortable, at first, if I'm being honest. Tight, further forward, visibility compromised, but once I got used to it (from Evoras past) I love the flattened, "shrunken around me" feel. Between that and the way it goes over the road, it simply feels very, very different in a way that can't be fully explained.
Eyes wide open, the Emira's mid-engine feel is a bit different than the Cayman. Center of gravity is a little higher maybe? It's not a rear-engine feel, but I can tell that the engine isn't as low.... doesn't bother me though. You have to be ready for "weird stuff". The Emira interior is creaky, the infotainment is a mixed bag on a reliability front, the car is way less practical, and the transmission is a love it or hate it affair... you simply cannot rush it, it's noisy as h_ll (I happen to like its weird chunky feel).
The 981 and 718 were objectively "better cars", in pretty much every regard. But I didn't yearn to be in them the way I do the Emira. Case in point: I sold my 718 after 9 months and only put about 3500 miles on the 981 in 30 months. I've had my Emira for 4 1/2 months and I've already got 3000 miles on it