For me the character death that hit me differently was probably Fred from Harry Potter (blurred spoiler incase people haven’t seen or read the book or been on the internet ever) I guess it hit me differently because he was always such a fun and nice character, so young too.
Tommy from The Shawshank Redemption. After Andy, knew that he was serving in jail for a crime he did not commit and had enough evidence though Tommy to get out, Andy finally saw hope for the first time. But his hope was short-lasting after the Warden finds out about it and, to prevent the truth from coming out, had Tommy killed straight by putting a bullet through him.
I never thought of any of the characters as straight (maybe except for octavian and Annabeth sometimes) but yeah Piper had major bi vibes (she’s bisexual and I knew it)
Though it is in the end end of the series you find out
Well, all the characters in Hazbin Hotel are already dead, but I’d say Alastor’s death was probably the scariest. I have a fear of dogs, and Al died by a dog attack.