Heartwarming Moments: During A World Without Superman, Batman intercepts a terrorist who wanted to blow up the funeral, and stated that in honor of his fallen friend, he was playing it by Superman's rules.
Hilarious in Hindsight: During "Reign of the Superman" a fan commented in his letter that "It's amazing how far comics have come in twenty years. Then Doomsday would have been some monster thrown from Krypton or something". When Doomsday's origin was eventually revealed, it turned out comics actually hadn't changed that much.
During his fight with Doomsday, Superman muses that he would suspect Luthor was responsible for creating Doomsday if he were still alive. Sure enough, Luthor ended up being the one who created Doomsday in Batman v Superman: Dawn of Justice.
Idiot Ball: Doomsday may be really tough, but he also presented absolutely no threat if he couldn't get within arm's reach of anything. Despite the Justice League having multiple telekinetics at the time, nobody thought of simply picking him up. Granted it probably wouldn't have worked since Doomsday was made unstoppable but point for trying.
As Max Landis "educational parody film" The Death and Return of Superman explains, this wasn't really the attitude of comic book readers at the time. At the time, death wasn't something focused on in comic books, especially the main characters dying. As such, when The Cape himself died, it was a big thing for both readers and people who didn't even bother reading comics. What caused this trope, then? After it happened to Superman, every comic book with a dead character decided that it would be equally cool to return.
Tear Jerker: Comes with the territory. Watching Superman's last blows with Doomsday, as his friends, colleagues, and family watch helplessly, is truly heart breaking.
The Woobie: Lois Lane. Watching the man she loves fighting and dies while still determine to recording the fight is hard enough, but what made her cross into this territory is that, unlike the other heroes and civilains, she is both completely powerless to do anything and, at this storyline, knows both Superman and Clark Kent. While the story focus is on actions, Lois's grieve and pain is detailed very clearly, especially with the four new Superman crop up later in the story.