I absolutely love the ending for FFIX. Of all the game endings I've seen, it's my favorite. It comes in 2nd for my favorite ending of anything (movies, games, etc.)
I would say the movie that has my favorite ending, but I am the only person in the world who likes the movie so I won't say.