I personally like the presence of spells that bring folks back to life. It allows me to play a bit harder on the players, throw in traps that are deadlier etc. It also let's me on good conscience throw in things that SoD (recently threw a phantasmal slayer at them). I also like the spells because it makes some threats much scarier, if death was death then all things that can potentially kill you carry the same amount of threat, but with rez spells, some things that aren't that scary, like bloodrots, become scarier since they turn your corpse into one of them and therefore raise dead and reincarnate can't be used.
ps. sorry for using almost all heroes of horror references, I just used some of the book recently so it's fresh on mind, a player rolled an archivist and started leading the party, so I felt I'd tie the story a bit closer to what he uses.
pps. the phantasmal slayer basically acts like a living wierd spell, if you manage to disbelieve the DC 26 will then all it has is a 2d6 touch attack. It's a cr 15 monster, they were lvl 10 avg.
-----The bloodrot is a undeadish slime that causes a curse disease that constantly hits every min for possible con dmg (another stat too but the con is deadly) upon death your body liquidates and turns into a bloodrot. No ressurection for you.