Look for a nicely kept 3rd Gen Mazda Miata (currently in 4th Gen production). They are pretty bulletproof mechanically, get great gas mileage, handle very well, are fun to drive and have a large aftermarket for performance improvements if you're so inclined. 3rd Gen cars were from 2006 to 2015, so pricing would be reasonable, and since many are bought as second or third vehicles, mileages on them are usually lower for their age.
I owned a 2nd Gen (2000 model) for 8 years from 2009-2017 and only sold it because it was getting more difficult for me to get in and out of due to my age and arthritic back issues. I drove mine as a daily driver and modified it heavily for performance, it was a 4.5 second 0-60 car. AFAIC, the 2nd gen is the best looking and along with the 1st gen is the purest in terms of a true sports car, they were early enough that there is less electronic "doo-daddery" than the 3rd and 4th Gen have. The 3rd Gen car has a version available (PRHT) with a power operated hardtop if you don't want a softtop car.