There is a reason the Miata/MX5 is the best selling roadster and sports car of all time. It does not have a ton of power, but it isn't supposed to. The dynamics and "fun" are great.
A Boxster (I'd suggest an S) is going to be very good, but also higher in price, of course. I'd stay clear of an...