I played with my driving mode switch today for fun, and sport mode does affect the transmission shift points the same as putting it into S on the shifter. So in that regard, they do the same thing, but using the paddles in full manual mode requires the shifter to be in S.