In a straight line, sport mode or manual mode will not be any faster since full throttle kickdown in any Drive mode will get you max accel.

SD and Manual are much better in the twisties though!