Call me sentimental, but there are similar scenes at the very end of 2 different movies (ironically, both of which are set in 1912) that give me the chills every time. One is the final scene of "Somewhere in Time" where Christopher Reeve finally gets to be with his love, Jane Seymour, forever, and that wonderfully melancholy music plays. I've seen that movie at least 3 dozen times, and I get all teary because that's the way I think Heaven will be: being with all my loved ones again, especially my baby daughter whom I never got to take home from the hospital.
The other scene, naturally, is the last one in "Titanic", with Leo and Kate coming together again and everyone who died on board, like the Captain and the little girl and Mr. Andrews, all applauding as they meet on the grand staircase. I'm not much of a weeper in real life; it's just the combination of sadness and joy that gets me. As Dolly Parton said in "Steel Magnolias" (another great tear-jerker): smiling through tears is my favorite emotion!