NA sports cars are getting harder and harder to find. I guess you can find an older 987 Boxster/Cayman or E9x M3. I can't think of many cars newer than that that sound decent. Frankly, I'd be happy just to not have fake engine noise piped into the cabin.
I know there is a sound tube mod that people do to ND Miatas to to give it more intake noise: