There is pain. There is also pleasure. Both are as weak or strong as you think they will be.

Some might experience death as floating away from their bodies to other planes of existence, others might just "respawn" as if in a videogame. It depends on what you think will happen, and on how shocking the death was. It's the fright of dying in itself that causes you to wake up rather than death itself, and a scary and sudden death will probably wake you up.