I looked at this and thought "what the hell's a Miata?"
I now realise it's a thread about an MX-5.
As a Mazda driver (sadly only a 6) I would recommend the RX-8, just on looks and te fact it's got the cool half suicide doors for the back seats.
If you want a small fun car that seats 2+2, you could do a LOT worse than a Renault Megane Coupe Cabriloet - as much fun as a basket of kittens and almost as pretty.