The only time i use the Manual mode is when driving up a rather large hill i frequent.
Speed is 55-60mph, and auto tries to hold 6th gear too long, forcing an awkward downshift half way up the hill.
I force it down to 4th as i start up the hill and am able to maintain throttle and speed.
At the hill crest, i pop back into auto.