Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: Two Thousand Ten The Year We Make Contact
Dave Bowman's visitation to his ex-wife and his mother.
HAL thanking Chandra for telling the truth, followed by HAL, just before death, essentially asking Chandra if there is an afterlife, followed by the touching exchange between HAL and Dave:
HAL-9000: What is going to happen?
Dave: Something wonderful.
HAL-9000: I'm afraid.
Dave: Don't be. We'll be together.
HAL-9000: Where will we be?
Dave: Where I am now.
In the movie, the death of Max Brailovsky. What sells it is Curnow's breakdown: