Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tearjerker: Pet Sematary
Louis weeping and cradling Gage's deceased body, and when Louis weeps as he carries Rachel's body to the burial ground, hoping she will come Back from the Dead.
The scene, both in the movie and the book, where Louis and his father-in-law start to fight at Gage's funeral, and knock over his coffin.
The coffin did not actually open and spill Gage's sad, hurt remains out onto the floor for all of them to gawp at, but Louis was sickly aware that they had only been spared that by the way the coffin had fallen—on its bottom instead of its side. ... Nonetheless in that split instant before the lid slammed shut on its broken latch again, he saw a flash of gray—the suit they had bought to put in the ground around Gage's body. And a bit of pink. Gage's hand, maybe. Sitting there on the floor, Louis put his face in his hands and began to weep.
Gage in general, but the scene where Louis remembers the cap full of blood, then dreams a whole life for Gage through his late teens...and then wakes up. Devastating.
In the film when Louis has to kill Gage so he can stay dead, and he starts crying before childishly going "No fair!" and then stumbling until he hits a wall and slumps down dead.