I actually find it very liberating, the fact (well, I believe it to be a fact) that there is no inherent purpose in life, and that there will be no afterlife. It means that what we are left with is like a blank canvas, something completely amorphous, that we are free to impose our own order on. Without God, or Heaven, our existence is like a block of marble that each of us must sculpt into something personally meaningful.
Is "spectacular" quite the right word? It seems to me to imply the existence of experience, and of a subject- which is obviously not nothing.I can only hope for nothing after death. That would be spectacular.