If you could live with a small sedan or coupe, and you need good fuel economy, find a clean e36 BMW 318i. The auto would not be nearly as much fun, but if you gotta have it, oh well.
If age does not concern you, a Mercedes W123 is an extremely nice car in every way. If you can find a good original, well worth having. Almost all US 123s are diesels and slow, and don't let the turbo on most of the 300s fool you. They're still slow, just not as much. The 124 (300E) and 201 (190E) are also very nice, as well as being durable and reliable, if you find a good car, not one that has been badly neglected.
More practical, and also pretty off-beat, would be any Subie.
Any turbo Sube is fast, and the automatic doesn't seem to hurt the Subes all that much.
Finally, for a closet sport sedan that is fun to drive and economical, any VTEC Accord.
If you go back far enough, and can find a decent one, there are even Accord wagons. Most of these you'll find are automatic, and my understanding is that the three generations from 1991-2002 have none of the trans problems of some later years.
Happy hunting, but those would be my picks, and I am limiting my suggestions to cars I have actually owned.