If more people would take the time to research and find out what they really want in a car as you have done, things would go much more smoothly at the car sales lots.
Almost everyone starts out with unrealistic goals. You initially wanted:
- Sport
- Luxury
- Sub $30K
- Reliability
- Coupe
- Non European
- 250+HP
- Good fuel economy
Several of these priorities are in conflict with eachother, but it worked out. I was getting that the main thing you were after was fun that wouldn't break the bank, and I think the Miata was a great choice for that. (Just make sure you run snows if this will be your daily winter driver!)
It misses on Luxury to be sure. Reliability? Eh, that's debateable. HP? No, but power to weight makes up for it. Fuel economy...it's ok. But fun? Definately.
If you didn't rule out Europeans, you might have stretched on budget to get more luxury in an older BMW Z4, or a Merc SLK.
For more power and more refinement, I'd have looked at an S2000.
For more raw excitment, a Caterham super 7 kit. Don't even think about driving this in remotely damp conditions though. It may be street legal, but it's no daily driver. A coworker of mine used to have one in the late 90's. It weighed less than 1200 lbs, and he built his with a Ford Focus 4 cylinder drivetrain. This thing had supercar acceleration and scared the hell out of anyone brave enough to shoehorn themselves into the pasenger "seat".