Miata is still the obvious answer here.
Not sure if you can still find any of the SC 3800-powered GM midsize sedans, but that'd be something else I'd look for.
Honda Fit
Any non-WRX turbo Subaru with 3 pedals (Outback XT)
5-speed V6 S197 Mustang
The most raggedy 3.5L Odyssey I could find
Any manual Mazda3