If you put it in sport mode, yet drive it like a 80 y.o. grandma, I don't think you will see any change that is benefitial.

However, if you are used to driving a maual transmission, and are driving hard, you might appreciate that it is not goingto change gears as often at inopportune times.