OP, I'm in the same boat as you're but plan on staying carless for some more time, and I own an sv650s. My wife wants an automatic and I try to drive MT as much as possible. Had leased a 2020 Corolla SE (CVT) and transferred it to someone else after a year. Good family car but doesn't suit me.
I would suggest 4th or 5th gen Honda Civic Si, Nissan 350z, Infiniti G35s/G37s coupe, Mazda Miata, and finally the overpriced BRZ/86.
350z and G coupes are a bit quicker than sv650 for sure. Haven't driven these but had many friends who owned one and they would drop a gear and disappear.
If 25k is your budget, buy something for 15k-17k and keep the rest to tend to maintenance/repairs. I learnt that the hard way lol.
Edit: same boat in terms of criteria.