I realize we have moved on from the MX-5 (Miata) conversation is that most performance cars will leave them in the dust. I'm totally fine with that. Straight out speed and power wins.
The reason the MX-5 is still appealing is the driving experience. You can wring it out, and have a blast. You can smile as you rip through corners. You get tons of feedback as you are getting to the edge where it is going to step out of line.
It won't impress your neighbors, but personally, I don't give a crap about what my neighbors thing of my car. All I care about is what it feels like to the driver.
I would have recommended a Mini in the past, because the drive was a blast. However it had a bad habit of peeing on my garage floor, and it felt like you would tear through the bushings in a couple of months after cornering with too much enthusiasm. It ended up being too much of a bother to maintain. And fun cars are supposed to be fun, not a bother.