FFX's ending was one of the best ending in JRPG ever. When Yuna fell through Titus when she tried to grab him literally made several people who were watching me play cry. It was such an amazing ending because it wasn't happily every after for everyone. You know one day that it might be happily ever after since you see Titus after the credits being reborn but you can't say for sure. This really leaves it up to the gamer to make their own ending to this story which is something I loved. This ending was so good that I ignore the fact that X-2 exists. I enjoyed X-2 to a small extent but it didn't come close to the endings I played out in my head over the last 10 years.
*Ok these next two games kinda move away from talking about the exact emotional moments in the games and move towards why I liked this games so much.
DA:O was a game were when you finished the game you wanted to play again that very instant. Reason being is that you were able to end one way but you knew there were so many other ways you wanted it to end, or at the very least try and make it end. Even the little choices like who would you romance, should you be male or female, your race, will you die when you fight the arch demon, or just having different party members with you this time around just to hear what they say. I think it took about 4 more completed games till I finally felt satisfied...for a while.
Halo Trilogy: The reason I enjoyed this game wasn't because I spent countless amount of hours online with my friends destroying others dreams of victory (though it helped). The reason I enjoyed this game was because it was a pure and simple epic story that you could just fall into. It was so enjoyable that I even read the books back when I hated to read, just because I loved the universe of Halo. Sure this game isn't as realistic a game as Modern Warfare is but its not as far out there as the DC universe. The heros in these stories really walk a fine line between being superheros and just normal humans. They are a lot like batman in the fact that they don't have any special powers (other then being on horse steroids) and really have to us combat skills to get them through their ordeals.