Yep, In the Pale Moonlight was awesome. Garak's speech, Sisko's closing scene, on the edge, risqué, a classic.
And also true in COC with Picard defiantly saying, "there...are.... FOUR lights!" after he gets rescued was one of the greatest.
Have a look at the ending of Balance of Terror - after Kirk talks to the widow of a crewman killed during the battle, he walks out into the main corridor as the credits roll.
There is something really modern looking about this scene.
I think it is the way they move the camera.