Star Trek (2009) - George Kirk hearing James' birth and saying goodbye to his wife.
The Dark Knight - Everything from the Two-Face showdown to the last shot, and then again when "In memory of our friends..." comes up
Titanic - Rose's death and reunion with Jack and the others who died on the ship
Titanic - Rose jumping back onto the ship, and the montage of the other passengers resigning to their fates (the mother and children, the eldery couple, etc.). Both of these scenes really pushed me over the edge because of the music. This movie was truly James Horner's finest hour.
Somewhere in Time - When Christopher Reeve dies and is reunited with Jane Seymour (
Titanic basically copied this)
Forrest Gump - Forrest talking at Jenny's grave
Before Sunrise - Finding out that they still go their separate ways (and honestly
Before Sunset ruined the first one because Ethan Hawke's character became so unlikeable)
Terminator 2 - The T-800 going into the molten steel
Robocop - Robo walking through Murphy's now-abandoned home
Revenge of the Sith - Intermittently starting from Padme landing on Mustafar to the closing shot
Saving Private Ryan - Pvt. Ryan standing at Miller's grave as an old man, telling him he hoped that he "earned it" and asking his wife to tell him he led a good life.
Jacob's Ladder - The ending where Tim Robbins returns home and the twist is revealed
And I'll throw in a television entry too...
Babylon 5: "Sleeping in Light" - The dinner toast to everyone who'd died, Sheridan and Delenn's goodbye in the hallway, Sheridan's death, the demolishion of Babylon 5, and the shot of Sheridan's spirit sitting next to Delenn during the sunrise.
That's about all I can remember. Guess I'm a bit of a sap. Oh well.