On my way into work today I played with the "manual mode" today. I've driven in "sport" mode and found it to be okay.... (I've had several manual cars, FWIW, I know how to drive one).
It was pretty fun, I have to admit. I assumed it would be more of a novelty.
It will up shift on it's own...