My favorite video game moment will always be the ending of FF9. I had already fallen in love with the game, but that ending is what forever sealed it as my favorite game of all time, and still does to this day. I still go back and play it and the ending still gives me goosebumps and makes me smile like a total dope. XD
Four other favorite video game moments that I have:
1. The opera house scene in FF6. I seriously have never felt that outright overwhelmed and impressed with a sequence in a video game before. It's just so amazingly executed, bringing in Celes' performance, Locke's dashing rescue, and... ULTROS! Heehee.
2. Blue Dragon spoilers (highlight for spoilers):
Reclaiming Shu's shadow and the scene directly preceding it. I was kind of on the edge about how much I liked Shu as a main character; that scene did it for me. I always love scenes that really do that much to sway my attitude about a character.
3. The "You're Not Alone" scene in FF9. I think it's partially the music, and partially the message behind it, but I loved the way it was executed, too.
4. Ookami spoilers (highlight for spoilers):
Right after the battle with the King of Darkness, when Issun sends out images of Amaterasu around Nippon, asking everyone to say prayers for her and remember how much she did for them. The music in that scene was heartwarming, and I was a complete sap and felt tears in my eyes... ^^;