Hey Jeff, we have a similar car background. I've had a ton of cars the past several years from the BRZ, Corolla GR, new Type S Integra, then on the other end an Escalade V, C6 ZR1, Ford Lightning, TRX, C8 Z51, Model S Plaid (new '24 I just got), etc. I've also driven the 4BW predecessor in anger on the track and autocross. I also own a 5BW six-speed.
As far as nimble sedans go, the 4BW is about as good as it gets. Yes, the LF4 engine isn't a world beater, but it gets the job done. The 5BW doesn't feel as nimble, but that LT4 is a monster and the 5BW can still dance when the road gets twisty. It doesn't feel nimble, but still very competent and fast. Think Chris Farley (RIP!) doing cartwheels.
As long as you know it's a 4k lb sedan, it kicks a**.
Best bet is to keep your Miata (or some other light, fun, nimble car) and then get a 4 or 5BW for all your other drives where you don't need absolute flickability. Best of both worlds.