With that I fully agree.
Granted, I don't have problem with revivify, as I see it as some sort of fantasy emergency treatment, where you revive a person who is technically dead in a sense that their heart has stopped etc, but they're not yet truly gone.
But with longer reach death reversal it creates this weird situation where dead people are just quantum dead. They could be revived later, and presumably the characters know this. So the death cannot be reacted to normally, it cannot be processed normally, it cannot have the dramatic impact it would have normally. I hate this.
My solution to this problem is to make of death a quest.
You want to resurrect your ally? It's gonna take more than
just a spell. Maybe it would be "just a spell" for someone deeply immersed in their faith or philosophy, but anyone like that is going to ask for some form of payment or exchange for their services. For the PCs to do it themselves, even if they have the
knowledge, they need something more.
Maybe, instead of diamonds, each resurrection ritual requires something special, commensurate to the strength or age of the separated soul. (Hence why those who have died "of old age" can't be brought back; at that age,
nothing is valuable enough.)
Or maybe a resurrection spell, of any kind, is simply something that lets you make a deal with Death, or with some divine figure, to get your friend's soul back. The diamonds are merely your "opening bid", your "downpayment" to show that your negotiation is
serious. Now you have to haggle for the soul--and you
know both Death and the gods won't expect anything less than equal value for the soul being restored. (Even unquestionably good gods cannot afford to be
profligate with their power--but perhaps they are already in your debt.)
Or maybe the spell projects the party into the Underworld, so they can aid their friend's escape from there. The stronger the spell, the stronger the helping PCs are while they're on the "other side" or the longer they can stay--but the stronger the target's soul, the deeper they "land" in the Underworld when they die.
Do stuff like this, and every death still
matters. It genuinely
tells a story, rather than simply being "Altogether, Jhen'ee adventured twenty-three hours, and then she died." And the above, all of it, has tons of precedent in myth and legend! Orpheus and Eurydice. Ishtar and Tammuz. Gilgamesh and Enkidu. All sorts of folklore involving a "sleep of death" or "apple of life" or the equivalent. A quest to go into the Underworld and return with power or a loved one's soul or something similar is literally almost as old as storytelling itself. Deals with the devil to restore a loved one to life--at a price. Etc.
If the player is genuinely done with the character and wants to move on, great. But if they aren't? We can do
so much more with it.