If you end up with no stick, the 5 speed automatic in the E36/46 BMWs is way better than the slush boxes of old. They all have the sport mode you can select by pushing the shifter to the left. It gives new meaning to the term 'drivetrain'. It practically reads your mind and usually picks the same shift points a sporty driver wants. In everyday driving I can make it shift when I want by a small momentary lift on the throttle.
Only down side the overly intrusive dynamic stability control which fortunately can be disabled.
I do like rowing the gears though, have to drive the Slingshot for my stick fix.
BTW, have you looked at the specs on the 2018 Civic type R? I wish to hell they had not gone so far with the 'Boy Racer' styling but it sounds like a real driver's car and offered only with a stick. If I lost my Z and couldn't find a good one, I'd consider it.