Potential SWTOR spoilers: Love the death of Darth Baras. The power that comes from surpassing your master and the music that plays as you kill him is wonderful.
Zelos Wilder from Tales of Symphonia really got me. First time I played through the game, I picked the path where he dies. It wasn't until I had played through the game with him and gotten to adore the guy that I realized what a fool I was.