I always tear up just a little at the ending of Lower Decks during Picard's shipwide announcement.
In "Family", it's not so much Picard's breakdown that gets me, but the hug that the two brothers share at the end of the episode. It just seems so heartfelt.
Also, Worf and Nikolai's similar brother-hug in "Homeward".
And Worf and future Alexander's hug in "Firstborn".
Guess I'm a hugger-lover!!