My Dad has a vette Z06 and a miata.  The miata is more fun to drive around town, the vette is better on long trips.  He finally dropped a supercharger into the miata though, and it makes a big difference.  The miata handles extremely well and now it has a surprising amount of power.