Obviously the character's afterlife won't have impact ingame, but for people immersed in the game, and roleplayers like me, it's kind of a stab in the gut to say your character can no longer go to Sovngarde, The big hist in the sky, the Ancestors plains, etc.
Companions does a bit of the same thing with Werewolves, albeit that is reversable, so I'm not as stickler about that.
Anyway, anybody else agree this is kind of a jerk move by Bethesda?

)