Yep. I started looking into sports cars recently, and the general consensus among enthusiasts seems to be that for public roads, if you're not going to drive at reckless speeds then you'll have more fun driving a slow car fast than driving a fast car slow. Fun handling with modest horsepower is the way to go, you can have a great time without exceeding normal road speeds.
That is why people love miatas.