Reading through this thread made me realize something. I don’t tend to cry at sad parts in movies. If done well, I feel sadness, but it ends there. When I end up crying, it is because a scene is more moving than sad. A scene can be positive, even, in an emotional way, and it can move me to tears. Like the end of Ordinary People. There’s nothing sad about that scene; it is uplifting to see father and son connect and heal old wounds in such a way. But it still makes me cry. Someone brought up the end of Rudy. Same thing.
I'll also throw out Star Trek II, not so much when Spock dies*, but Kirk's beautifully, simple eulogy, and Amazing Grace on the bagpipes.
* Interesting backstory on how all that came about, from the original idea, to how it evolved, to trying to keep it under wraps. Even back in 1982 word got out ahead of time that ‘omg they were going to kill Spock!’