An automatic transmission is great for convenience and raw acceleration performance.
A manual transmission is great for feeling connected to the vehicle and the driving experience.
It's all a matter of what works best for you. I tend to err towards auto given where I live, but if I was a bit more out in the country with those windy country roads, manual would be the play.