Best Openings:
Colony Wars: Vengence
World of Warcraft (Solely for the vista in the Tauren's little segment)
Suikoden II

Best Endings:
Star Ocean 2 (Several of them, in fact.)
FF VIII
FF X

Best scenes in general:
FF VIII
FF X
Legend of Dragoon
Chrono Cross