I always liked the Kingdom Hearts 1 opening. Really sets the mood for this convoluted clustersmurf of a game.

The You're Not Alone cutscene in FF9 was plain deep.