The 6-speed stick was offered with the uplevel 230hp V6 in the GS Sedan and LS Coupe. Not sure of other specific applications, but I do remember those two.
C&D ran a 6-spd Coupe to 60mph somewhere in the mid or low 6-second range way back when. I'm sure I can dig it up if anyone's that curious...