FFXII's opening FMV was pretty great with the Star Wars/LoTR-esque massive war sequence. FFVIII's was great too, obviously.

FFX probably has my favorite ending. Bittersweet tragedy was never more pretty!