Scenes that bring on the waterworks, at least at this point in my life, tend to hit me on a surprisingly personal level, and they tend to be very layered. The super obvious tearjerker-for-the-sake-of-being tearjerker scenes rarely do it for me.
Death scenes don't have to be literal. They can be about the death of a friendship/relationship, or the death of someone's dreams. That hits me especially hard as someone who has yet to pursue her own.
A scene in the most recent season of BoJack Horseman involved a character finally giving up on her childhood dream, symbolized in one simple action. No dialogue needed to be spoken, and all of the scenes leading up to it gave it that full emotional impact. I should mention that this character was only just introduced this season, and the scene in question was from episode... 3? That just goes to show that you don't need a season's (or more) worth of buildup to have an effective emotional payoff, just decent writing. And have I mentioned how great this show is? It is such a great show, you guys.
Also, scenes can be both happy and sad, and thus be all the more impactful. Take the ending of Coco for instance. I get weepy just thinking about it. But in the best way 