"but power over death should be something that only chosen few have."
Um.. That's exactly the way it is. 9th level + clerics don't grow on trees. Not to mention that in pnp, it takes a heavy penalty along with it (1 level which can be costly), and expensive material component IIRC, and most npc clerics don't go freely casting for everyone. Also, IIRC, and this might be different in 3.5 (or even 3/0 as it's been awhile) you cna only be ressurected a maximum of whatever your constitition is before you are permenately wiped out.
And, yeah, I hope they still have ressurection/raise dead spells in NWN2. I've asked this question on the NWN2 Boards...