Was wondering when this was going to be brought up.
Raise Dead - and spells like it - causes far too many issues in regards to versimilitude. No one of any importance would die, save by old age.
Actually, the idea that important people would be raised from the dead threatens my versimlitude. In fact, by law in most of my world it's illegal to raise an 'important person' from the dead in most cases. Once you are dead, threatening the natural order of the world by bringing you back tends to cause way too many problems.
For example, suppose you have a situation where a King is killed. At that point, his 40 year old son is now the lawful king after having waited to obtain the throne for many years. If you raise the king back to life, does his son cease to be king and must he now keep waiting? Is it possible to have reverse succession? Can a king be uncrowned? Can you have two lawful kings? Will now the son resent the father, or if resentment is already present, will it be increased? Will the father even want to be returned to life, seeing as he must now supplant his son? Suppose the son and the king were not of like mind and desired to follow very different policies, and to place very different advisors in high station? Won't there be immediate conflict between the son and the father, and between the supporters of the two administrations?
In the history of my world, there have been way too many feuds and civil wars that came about in centuries past because someone decided to ressurect a dead prince. Brother vs. brother, father vs. son, even in cases that before the death the two had held a loving and respectful relationship. Brothers have agreed to have their older sibling raised and restored to the successsion, only to become resentful when they see the policies the brothers put in place and regret it. Thousands of people have died just so someone could have a few more years of mortal life. At some point, society said, "It's not worth it." In general, it's illegal by law and custom to raise a person from the dead if they have an adult heir unless the adult heir is the one guilty of the murder. And in general, everyone has to want the dead person back before the priests will attempt it. Family members are interviewed privately before a decision is made, consultations are made with the divine, and only then is raise the dead person considered.
Further to that, there are lots of reasons why a dead person might not want to come back to life. In general, most NPCs don't have a mortal destiny that they will deem worth it to come back for. PCs are among the most common sorts that are actually raised because they usually have destinies to fulfill and no heirs or other entanglements complicating things.
I'd think its actually more likely the unimportant persons that get raised, at least if we are talking about nominally good temples. That's among the reasons temples charge wealthy adventurers for spells. It's so that woodcutter who is his families sole source of livelihood can be brought back and without whom, the family is rendered destitute, the children fatherless, and the wife berieved. There is generally little concern over whether an 'important' dead person is brought back. The only time that happens is in nations with 'immortal' autocrats that have loyal panapoly in place to keep them on the throne no matter what happens. And in those cases, its most likely that the death involved an attempt to subvert that, and so an attack on the loyal priests occurred as part of the coup and various attempts were made to put the body beyond restoration.
This isn't merely a theoretical consideration. It's written into the plots of my game. In fact, in the current murder mystery scenario this is playing out pretty much in the way I consider typical.
A doting mother of a wealthy and politically connected noble family, has had her son, the clan chief murdered. She's petitioned the king and the temple to raise her son from the dead. Both are going to refuse her request as being unwise.
a) Though she doesn't know it, her younger son resents the older son because the older has always been her favorite. This despite the fact that by personality, the older is a semi-autstiic recluse incapable of providing proper leadership to the clan and the younger is ambitious socially gregarious ruthless person similar to herself and who is actually involved in the day to day running of the clan. As things stand, the younger would retain his loyalty to his 'foolish' older brother. But the death of his brother has changed the dynamic, and awakened the younger's ambition to possibilties he hither considered imposible. If the older brother were actually raised from the dead, in a few years time not only would the younger brother murder his older brother, but probably the older brother's children as well.
b) If the situation was reversed, the outcome would be little better. The younger brother and the overall alignment of the household is LE. The older brother is LG. If the older brother where the younger, and the younger older and murdered, the same resentment would eventually develop. The older LG brother wanted to change the way the clan behaved. Had his ruthless brother been raised from the dead, he'd have been tempted eventually wrest control of the clan from him by force - probably leading to a clan wide lethal feud that would have killed scores of people and led to the King intervening.
c) The King doesn't directly know these things, but the King is currently embroiled in putting down a minor rebellion. The last thing he wants to do right now is break traditions, be seen to favor the aristocracy, and create the possibility of additional turmoil in one of the clans.
d) The Temple doesn't know these things, but does know that the diety has said 'no' regarding all the questions they've asked regarding this matter (the mother is a major financial backer, so its worth asking). They know that no good is going to come from bringing him back, that the diety in question (who does know this) said 'no', and they know that the murdered brother is unwilling to return. Ultimately, all they can do is convey to the grieving family that the soul of their beloved has been conveyed successfully to his immortal life in the outer planes and is happy there.