As presented in Dungeons & Dragons, spells that restore life to the dead actual life, not an undead existence would have catastrophic effects on any world if taken to their logical conclusion. The primary culprits are the clerical spells raise dead and resurrection. Unsustainable population explosions are often cited as one side effect of this boon. Another, likelier, byproduct of such spells would be the inevitable rise of theocracies wherever there are clerics with the ability to cast them. Surely the ultimate tool that could be used to win converts would be the allure of eternal life. Surely the primary form of corruption would be the fleecing of the wealthiest to ensure their resurrection. The highest level clerics would inevitably become either the power behind the throne, effectively reducing all monarchs to puppets, or they would rule outright. Who would deny their legitimacy at the risk of losing the opportunity to be resurrected? In such a world, the primary concern of all people would be to earn the right to be resurrected. All wars would be religious wars, because every nation would be under the direct control of a specific religion. The ultimate form of rebellion would be the deliberate rejection of resurrection and those who control it. All of this is fine for an alternative dystopia, but it utterly fails to reflect any fantasy world I've seen depicted in literature or gaming.
Apart from the vast global implications of resurrection spells, what about the personal implications? If I am playing a lawful good cleric capable of casting resurrection, how could I not spend the rest of my days restoring life to every corpse brought to me by a grieving relative? Do all clerics rise in level to become resurrection factories? How can one be selective without being consumed with guilt? Whether the scale is large or small, raise dead and resurrection as standard clerical spells simply fail to support the emulation of any fantasy world I've ever read about, gamed in, or seen. That is why I would abolish them.
I would be willing to consider resurrection as a unique power that might exist in a single relic, or which might be granted by a god under extraordinarily rare conditions (perhaps once per century... or millennium), but as a spell, most emphatically no.
Reincarnation is another matter.