This applies more to the Big Two than creator-owned work.
I bring this up because there have been some well know characters dying of late at Marvel and DC and Marvel is promising a “major” death in an upcoming issue of Civil War II.
For me, hearing a character at the Big Two has died is meaningless. You know at some point they will be brought back, despite what talent and Editorial swear. There is hype leading up to the death and hype leading up to the return. Some will stay dead longer than others but eventually, they will come back. The knowledge of the inevitable return takes away the impact and meaning of the death.
Deaths and returns seem to basically be a marketing ploy to push sales. It comes across as the only way to show that an “event” is important. It would probably have more impact if almost every well-know character hasn’t already had at least one death/return.
For me, I find it more interesting when a character is faced with a moral/ethical quandary than a simple life or death one. Death is easy. Their responsibility ends. But when a character makes a decision with consequences and has to deal with them, there is real storytelling potential there.
This all ties into the larger question of the “illusion of change” in comics.