Zack in Crisis Core - probably the most emotional moment in any Final Fantasy game, even knowing that it is going to happen from the start. It was done incredibly well, as you manage to get so attached to him throughout the game.