I only use manual mode in really sport driving when I want an element of control. Sport mode is often enough for spirited driving. In manual mode, I usually upshift around 4500rpm to 5500rpm if I want to drive hard. I rarely redline no matter what (guilty conscience don't know why).