I'm an atheist, but I personally think religion is generally good, especially since it does bring so many happiness and fulfillment. If something can provide you meaning, comfort, and community then who am I to question or attack your beliefs.
That said, in a weird way I would hope that even if there is an afterlife, that I am spared it. Nothingness might sound scary, but I would vastly prefer to return to whatever void my existence was before birth. If when I die, I wake up in heaven, I'll probably get sent to hell for immediately trying to kill god lol.
Weirdly, I think everything could go right in my life and I'm just far too gone. I acknowledge such negativity is probably holding me further back, but I don't really care at this point. I'm just sick of suffering, even if it's a minuscule amount I'd much prefer complete nothingness.