Just on the other night: In "The Professional"--a movie which has several great scenes--when Mathilda gets back from the market and has to walk by her apartment door, right past the corpses of her family, and she knocks on Leon's door, scared for her life, praying he answers the door. Leon, his mind twisting the permutations, Mexican holds his pistol and opens the door and she is sheathed in white light as he opens the door.
When Stansfield corners her in the men's room. Pure evil, one of the best bad guys ever seen on screen. I imagine sometimes poor Natalie Portman wakes up with nightmares of that dude.
Cindy and Waylander, I'll also vote for the very end of "Braveheart", when he's dying and sees his wife walking through the crowd, waiting for him. It's a motif he used in "The Passion", too, I believe.
In "Gladiator" when the Praetorians emerge in those long cloaks and form a circle around Maximus as Commodus comes out and Max gives him sh!te. Again, when the Guard turns their collective back on Commodus, if only for a moment. The "Are You Not Entertained" bit.
"Road Warrior"--a movie of nothing BUT great moments--when Max shoos away the Feral Kid and then throws him the little turnkey music box; when the battered Gyro captain trundles up to a bloodied, beaten Max, pulls up his googles, and they share a smile; when Papagallo offers Max a place with them and he refuses.
"Blade Runner", as Batty is descending the elevator after doing bad things to Tyrell. I've never understood why Rutger Hauer didn't become a major star after that movie--he blows Harrison Ford off the screen.
A sentimental favorite--the very very end of "The Fountainhead", maybe one of the corniest moments in film history but still moving, as the elevator reaches the top floor.
Although I've come to despise him, at the end of "Manhattan", there's some sweeping panoramas of the New York skyline and great orchestral music--very romantic, especially in an era when almost every contemporary movie set in New York City showed the town as crappy and degenerate.