Would it be better to be fully conscious at the time of death?

Do altered brain waves make a difference when one enters the afterlife?

Alpha, beta, delta, theta, etc....? If a person is in a sleep or even coma state, is the transition any different?