TWOK: Spock's death.
What You Leave Behind: The montage of scenes from the series, especially those depicting friendship.
The Inner Light: Final scene as Picard clutches the flute and then begins to play a dirge for the people he loved.
Definitely had that "about to cry" feeling and moist eyes, but never all out sobbing.
In TWOK when Kirk is saying "Spock" behind the shield, where you can see his lips move but no sound, followed by that sad hopeless look on his face. Then later at the funeral when Kirk stumbles on "most human" during the eulogy. I really thought this was it, Spock was gone from Star Trek from that point on.
In Inner Light, as Picard realizes what is happening as he sees Batai come back, saying "Oh, it's me, isn't it?" How it all unfolds from there to that final point where he's playing the whistle/flute thing.
In Sarek, when Picard can't contain the emotions of Sarek and he starts to lose it.
There are probably a few more, but I can't recall them right now.