Sport mode in my 7MT is a no brainer, as others have said it allows the turbo to kick in at lower RPMs and makes a huge positive difference, especially in 3rd/4th gears. However, don't like sport mode in my better-half's auto, the shifting pattern feels harsh and engine revs too high before...
I drive a 2dr BD with 7MT. Better half drives 4dr OBX auto. Both 2.3 non-squatch. We love both.
But I REALLY love to drive the 2dr 7MT, it is a blast. On stock 32s 1st and 2nd felt a little too low geared, but now with 35s it is much better. Gets after it once you hit 3rd.
Drove 2.7...