My favorite has to be "The Extreme" from FF VIII, it's haunting yet beautiful, especially the opening notes.