This is based on opinion. Please don't list it on a work's trope example list.
Tear Jerker / Ultimate Spider-Man
Uncle Ben has died. Do we need to add something else?
Did you ever read Spider-Man comics before? No? You were starting here? Then, the first arc surely qualifies. For longtime readers, Uncle Ben is the ultimate Death by Origin Story, so there was not much surprise. But, for the rest... in the first issues uncle Ben seemed to be a good and open mindedparental figure, and a Reasonable Authority Figure. Peter may yell at him, and instead of getting angry, he is the type of guy who understands that he's enduring a lot. He finds Peter, who had run away from home, and instead of being strict he gives him some words of wisdom. Peter runs away, and finally decides to go home and tell them about those powers he got. But when he arrives, there are police cars at his home. A petty thief got into their house, and shot him while trying to rob them. Overhearing the police comlinks, Peter goes after him, defeats him, and finds out that he's a thief that he had seen before and did not stop. He blamed himself for what happened, and finally learned that with great power Comes Great Responsibility. When he arrived home, Mary Jane was waiting him. She had a Mistaken for Cheating earlier, but forgot all about that and gave him a much needed hug.
Ultimate Spider-Man gets a few, but one of the most poignant is after J. Jonah Jameson fires Peter. After a run-in with the Kingpin's goons (during which Spider-Man saved him) and a fierce phone call from Aunt May, Jameson walks to Peter's house late at night and waits for him to return. He sits with Peter on the stoop and gives a heartfelt explanation of why he snapped and fired Peter when he asked what was so wrong with Spider-Man. Jameson, in a rare sympathetic moment, tells Peter that a few years ago his son, who meant the world to him, was killed in a NASA shuttle accident. The agency sealed everything off as classified, and Jameson didn't even get a body to bury. He says that his son was a hero, that men like that are real heroes, and that people like Spider-man just cause chaos. Even though the reader (and obviously Peter) disagree with him on that issue, it is such a heartwarming yet simultaneously heart-wrenching moment of weakness and grief from the grouchy old man that no one can hold it against him, topped off by Jameson rehiring Peter and telling him that he'll assign him to Ben Urich so that he can learn what reporting is really about.
And Jameson's realization that he was wrong about Spider-Man, something that sadly could never happen in the mainstream series thanks to Status Quo Is God.
The Venom arc, which deals with the fate of Richard and Mary Parker, has more than a few. It begins with Peter finding an old home movie of when his parents were alive, at a meeting he's actually forgotten. Every now and then we cut from the video to Peter just staring in shock at the screen. After a few pages, May comes into the room as well. Ben's in the video as well.
Richard's videos. Just seeing the man crowing about trying to cure cancer, and make the world a better place, compared to his later tapes, where he's just broken. And the reason for why he's trying to cure cancer: His father died of cancer when he was younger, and he doesn't want any other children to lose their parents. And what does he get for his troubles? Lawsuit after lawsuit after lawsuit, and we're never even given a reason as to why the company he worked for did this to him.
The Symbiote Wars arc makes it even worse, when Peter tries researching his father, and he doesn't find a thing. Not even a footnote. This despite the fact that he had published papers, he had done things in his life, people knew him, and now he's just an Unperson. Then, just to make things even worse, the company that did this to him appropriated his research and claim it's theirs.
The death of Gwen Stacy. It's just so quick and random. And meanwhile Peter is having one of the best days of his life since he became Spider-Man, until he comes home.
Aunt May tries to contact Gwen's mother afterwards. The woman doesn't care to listen, and May gets so angry she starts swearing down the phone.
The tragedy is a bit lessened by the fact that Gwen eventually gets better, in a very bizarre way.
The Clone Saga has several. May's heart-attack being one of them, but even worse is her yelling at Peter beforehand. She's basically his second mother, and all of a sudden she just starts saying these incredibly angry things and telling him to get out of her life, or the fact that when she has her heart-attack, Peter can't even do anything for her, much less get Nick Fury to help.
The reveal that nope, Peter's dad really is dead.
Harry Osborn's death. Even his father agrees he's gone too far at that point, and asks for someone to kill him. Too bad it didn't take.
Kitty's breakdown after the FBI try to arrest her, just for being a Mutant, and the fact that she fights her friends, lecturing them for barely standing up for her.
And the reaction of her mother, who's just left alone in her house with no way to reach her daughter.
The aftermath of the Chameleons storyline. Gwen is so shaken by what's happened that she runs away.
Fortunately she comes back a few issues later, only to reveal what happened: She went to find her mother, who was living with a new family and didn't want to see her daughter. Gwen very quickly breaks down into tears.
The Death of Spider-Man wrings every last tear out, as Peter dies in Aunt May's arms after successfully saving her from the Sinister Six. The variant covers were just as bad, with the final issue having him arm-in-arm with Uncle Ben, who told him he did good.
Aunt May: "What did you do, boy? What did you do?" Peter: "It's ok. I—I did it." Aunt May: "Just—Just hold on. The ambulance is—" Peter: Don't you see... it's okay. I did it. I couldn't save him. Uncle Ben. I couldn't save him... No matter what I did. But I saved you. I did it. I did..." (Peter closes his eyes and goes limp. Johnny puts his ear against his chest and, to everyone's horror, heard nothing.) Aunt May: (crying hysterically) Nooo! Oh god! Not him too!! PLEASE!! Not him too!! Oh god!! Please!! Please no!!
All of Ultimate Fallout. Everyone's reaction to Peter's death is emotional. Captain America QUITS over it, Nick Fury also feels responsible, and the city of New York mourns, to the point that thousands pay their respects at the funeral.
Mary Jane: "What are you going to do to me...?" Nick Fury: "I loved him." Mary Jane looks at him in shock. "I met him when he was just a baby. His parents were working on a project for us." Mary Jane: "You knew his parents?" Nick Fury: "Yes." Mary Jane: "I-I didn't know that." Nick Fury: "When his parents died, I wondered if I there was any way I'd be able to do right by them. And then I was so excited when he had the accident that gave him his powers. Now I could do something. I was grooming him, you know. I was so sure he would grow up to be the man his father wanted him to be and so much more. This brave, one-of-a-kind genius little boy. I should have taught him more, I should have slowed down the world so a boy like him could become the man he was supposed to become." Mary Jane: "I didn't know you knew his parents." Nick Fury pauses and she continues. "Okay I won't-I'm not going to send out anything I wrote. I didn't know.' Nick Fury: "I understand you're looking for someone to blame for this...my point is...you blame me...and I came to tell you...you're absolutely right.*tear goes down his cheek*"
The first Fallout issue is this for pretty much every page.
The opening page has Johnny Storm standing on top of the Baxter Building. His face distorts in pure rage and grief and he flames on so hard he lights up the whole skyline.
When Aunt May invites Gwen to live with her and Peter, and Gwen just throws herself into her arms and starts to bawl.
The lottery. Every single kid there is gifted, but whether they're going to get a decent chance depends on whether they're lucky enough to be picked from a lottery.
Miles' mother dying in his arms is heart wrenching. Made worse the next day when he wakes up to realize the nightmare was real.
Spider-Men features the exchange where 616 Spider-Man meets Ultimate Aunt May and Gwen Stacy. They're naturally asking lots of questions about their counterparts, and when Gwen asks Peter what she's like in his world, he hesitates for a moment, then just smiles and tells her that she's awesome.
What companies like Roxxon do to people like Spider-Woman or Cloak and Dagger all for the sake of the almighty dollar! i.e Tandy and Tyrone were just your average high school sweethearts who had their whole lives ahead of them, but after a near fatal car crash on prom night, they are spirited away to Roxxon industries where they are genetically tampered with against their will (the couple were somewhat dead following the car wreck but still) in an attempt by Roxxon to replicate the success of the super soldier serum much like Norman Osborn or Justin Hammer tried to in the past and if that weren't bad enough, people in this reality dislike (most) super powered individuals in this reality even more than in 616! As Jessica Drew puts it to Miles Morales:
Jessica Drew: (to Miles about Roxxon's true nature) "These monsters are going to try and try and try to remake you and me and Captain America and the Hulk...And they are going to keep trying and they don't care who gets hurt! They just want the money!"
Just the fact alone that due to the events of Secret Wars (2015), all of these characters that readers had been following for 15 years, are dead, with the expection of Miles and his supporting cast.