Actually, quite a lot of US-market cars still offer transmissions that aren’t designed for the lame and stupid.

Off the top of my head:
Quite a few Nissan cars (Versa?), smaller Toyotas, some BMWs, 4-cyl Subarus, Honda Civic/Accord, Chevy Cruze, Ford Fusion (4-cyl) and Fiesta, Dodge Dart, almost all Mazdas, bunch of small Hyundais and Kias, almost all Porsches (of course), VW Jetta and Golf, Buick Regal, even an SLK Mercedes.

Problem is that you practically have to grab a dealer by the b@lls and start twisting to get them to special order one.