That is a very good motor and pretty good on fuel. It isn't perfect, but it is one of the best Chevrolet motors.
I personally would not put an automatic in anything if I had a choice. The five speed manual sounds like a good choice to me, with the overdrive.