Episodes have never moved me, in their entirety - just pieces of some of them have, and usually at, or near, the end.
Like, in "Measure of a Man" when Data comes looking for Riker, at the end, to show his friendship. In a similar vein, there's VOYAGER's "The Chute," where Paris informs Harry, "You know what I remember? Someone saying, 'this Man is my friend. Nobody touches him.' I'll remember that, for a long time." Also, in TNG's "The Child," when Deanna's grieving and everybody in the room departs. Or in the episode "Sarek," when Sarek tells Picard, "Your courage honours me." And a little later on, when Bev holds the distraught Picard, I am very moved by that ... emotionally. DS9's "The Emissary" is an emotional bath, as well. A lot of Human drama in that one, "... You exist here."
And in the TOS episode, "Operation Annihilate" when Bones blinds Spock, unnecessarily and everyone believes it's permanent. McCoy was very sympathetic, showing how guilt-ridden he felt about the whole ordeal. That, more-so than Spock's actual condition is what I found moving about that. Plus, Kirk's family is in jeopardy and all of that. And in ENTERPRISE, I hate - absolutely hate - how emotionally manipulative "Terra Prime" is, but it's difficult to watch Trip & T'Pol's circumstance. "Make some good come from this, Captain." And these are but the tip of the iceberg. If you're looking for Emotional Impact, look no further than STAR TREK.