This is based on opinion. Please don't list it on a work's trope example list.
Tear Jerker / Terminator 2: Judgment Day
Doubles as in-universe tearjerker: Sarah harshly Complaining About Rescues They Don't Like when she reunites with John, who was expecting some warmth and affection, but is instead devastated by her callous response.
The novelization takes it a step further; Sarah has been desperate to toughen up her son, to prepare him for the war to come, but seeing the hate in his eyes after brushing him off, she laments at how much this whole mess has cost them.
John and the T-800 watch a couple kids play with toy guns:
"We're not going to make it, are we? People, I mean."
As Sarah Connor was about to murder Dyson in cold-blood in front of his family, she realizes that she has become exactly like what she hates the most, and collapses weeping in guilt.
Sarah is trying to steel herself in killing Dyson by shouting, "IT'S ALL YOUR FAULT!" Dyson, bleeding from a previous gunshot wound innocently utters, "What?" He was about to be killed in front of his family and he honestly does not know why.
The "burning playground" opening, juxtaposed to Brad Fidel's gentle and heartfelt rendition of the "Terminator Theme" strikes just the right emotional nerves, reminding us of how important it is to save this world for the next generation.
Hell, this entire sequence is a Tear Jerker. It's VERY heartrending to see John pleading the T-800 not to go. Even after you consider that it was the closest he ever got to have a father figure. Doubles as a Heartwarming Moment, when watched back-to-back with Sarah's final speech in the movie.
The Final First Hug between the T-800 and John is pretty heartbreaking too.
The T-800 and Sarah are both being The Stoic, as they know that this has to happen in order to prevent the creation of Skynet. John, however, simply descends into Inelegant Blubbering that leads to a truly heartbreaking Heroic BSOD:
The look on Sarah's face right before she hits the button to lower the T-800 says it all; from the moment she first saw it, despite the fact that John's survival was its mission, she hadn't trusted it, all but vowing to destroy it at the first opportunity. Now, in the end, she has her chance....and she clearly doesn't want to.
Sarah's last line from the film:
Sarah: The unknown future rolls toward us. I face it, for the first time, with a sense of hope. Because if a machine, a Terminator, can learn the value of human life, maybe we can too.