But the whole ending in FF7 was extremely beautifully made.
It's not just some particle effects. You know that is Holy and Lifestream, the reason for Aeris' sacrifice and within the lifestream there is Aeris herself destroying Meteor.
(That's gonna sound pretty stupid to those who haven't played the game...)
And the part where Red XIII climbs the cliff with his cubs and sees the destroyed Midgar and then the Final Fantsy VII logo appears on the screen which is followed by a fade to black and children's laughter in the backgroung. Just thinking about it brings tears to my eyes.