I can't pick a favorite moment, there were so many good ones.
I do agree with Fan however that the opening sequence set up an operatic mythology for Kirk.
On an emotional note, I loved it when Robau says: "You're captain now, Mr. Kirk." and we see the very reluctant, yet determined look of George Kirk.