This is going to be long winded so my apologies up front. For a real race car at a track day car you'll need at least some type of sports racer for most groups as open wheelers aren't always welcome.
I was at a track day today and I drove a friends Exocet, it was pretty good, I took it out in an intermediate group, as he was driving it in the fast group, and I pretty much passed everyone. It was well a balanced and easy to drive.
Spec Racers go well but they are lacking in power. If you can run in a group with open passing then they are not a problem.
I run an F500 at Autocross and even with the road race set-up you'll still manage a top 5 finish. Properly set up for auto-x you'll spank everyone except the shifter karts BUT you can't do most track day groups
I used to take my D Sports Racer to track days and in general was 10 - 20 seconds a lap faster than the fastest street car depending on the course configuration. You can actually find an older chassis DSR for the same price as a SRF and if you run the stock bike engine the maintenance isn't horrendous. The down side is these are cars can be a bridge to far as they are faster than many drivers can cope with.
The street legal aspect is indeed a bonus. Both the Datsun and the F500 need to be trailered; if I stage everything in the garage a day or two before the event, loading up for the track can be done in as little as an hour. By contrast when I raced a showroom stock Miata I brought minimal tools and spares it took me maybe 20-30 minutes to get ready. I also daily drove the car.
My recommendation is if it doesn't already have good suspension put some on the Miata, do a moderate brake upgrade, add some power but still keep it streetable and then drive and enjoy.
Here is why I say stick to the Miata; I drive my Datsun 1200 vintage racer at track days, 1814lbs with driver and about 100 WHP. Top speed on Spring Mountian Motorsports 3.4 mile layout is 110 mph and lap times similar to good Spec Miata. Myself and a coule of other instructors in gutless wonders go out in the intermediate group.
As mentioned earlier in the post I was a track day on Saturday, mygroup had about 30 cars and I was faster than about 28 of them. I should not be passing ZO6/7s, Caymen S, 911 GT-3s etc. on sticky tires, yeah I'm instructing and yeah the drivers I'm passing aren't as experienced but they would be better served to give up their 300-500 horsepower wide track wonders.
So I know this is obnoxious but if as a driver you have an instructor on board you do not need to be in a truly fast car. Kudos to anyone who asks for an instructor to ride along as feedback works wonders, please don't think I am denegrating anyone, it's just easier to hone your skills when reference points aren't rushing up on you. My preference is to at least get near the limit in what ever I'm driving. I don't want to be the guy chugging around in an old GTP car..........not that I can afford one.
A friend has a 250hp turbo Miata, it's fast and entertaining. Keep driving a Miata and improve it over time. A Miata doesn't have to be slow.
Tom