Speaking of respawns, I hate it when games let you casually (and canonically) revive dead characters. The only time I've seen this work is in Darksouls, where it's a major aspect of the game's lore. Amulets of life-saving or something else appropriately rare also works.
But if it's just some service the church offers for 1000 golden pieces, the implications are too great. I don't understand how you can have a service like this exist and everyone still acts like death carries the same weight as does in real life.
Yeah resurrection is something I have a huge problem with, especially when I write my own shit. I usually cut it out of every setting I work on because it introduces so many plot holes.
The king was assassinated! Okay, so what? He's the king. He has a treasury in the millions. Just send a bishop to rez him and he'll be back on the throne in no time.
Someone was murdered and we don't know the culprit! Okay, so what? Call a cleric to resurrect the dead guy, then we'll ask him who the murderer was and we'll find the culprit in no time.
Other powerful magic is also problematic. Things like "create water" or "create food". There's a draught in the country, so what? Call a bunch of clerics to cast create water on the fields. There's a famine in a small village? Send a bunch of clerics to create food there.
If death, famine, disease can all be defeated by magic (and usually create food and heal disease aren't even that high level magic spells), a lot of plot points fall flat. When your game has a murder mystery but 1000 gold at the temple resurrects anyone, you can just carry the corpse there and ask the resurrected guy who killed him. When your game has a famine but there's food creation spells, you could just cast goodberries - a level one druid spell - until the entire town is fed. Here's what the spell does: "Up to ten berries appear in your hand and are infused with magic for the
Duration. A creature can use its action to eat one berry. Eating a berry restores 1 hit point, and the berry provides enough nourishment to sustain a creature for one day."
And since it's a level one spell, a mid-level caster has enough casts per day that he can create 30 or 40 of these things. That's 40 people fully fed for a whole day, each day. Famine gone.
A lot of crisis situations can conveniently be averted by casting common spells. And yes, even resurrection is a common spell since usually temples are run by high level clerics who can cast at least one resurrection per day.
Most games just ignore the existence of these spells for plot reasons. So why include them in the first place? They're terrible spells that rape the logic of the setting.