I thought the Final Fantasy VI ending theme was absolutely stunning, the transaction between at the character's themes was very well executed, especially Locke and Celes.
I also liked the ending theme in Metal Gear Solid but that may just be because it was one of the first ending themes Ive ever heard.