I'm with Kyra - you die, you're dead, you only 'live' on in the memories of those left behind.
As to whether this is comforting or not, it's kind of irrelevant really. If we measured truth by how comforting something was we'd be in a very bad state.
With that said, it did used to bother me, but now I'm generally relaxed about the notion. A lot of it - most of it - is just ego - as organisms, we find it hard to believe that we could possbily cease to be, but thinking rationally, this is a nonsense.
We are comprised of a few atoms in the vastness of the universe. I could place a small weight on the zero key of my keyboard and leave it to run forever and still wouldn't have enough noughts to express the atoms that make me as a fraction of all atoms in the universe. On a universal scale, we are so irrelevant it defies computation. If we had never existed, the universe could scarecely notice less, even the most influential person ever (Brian Blessed) is irrelevant on a universal scale. Why should we worry about something of such inconsequence?
We also know that we did not exist before a certain point in time. Was that painful or scary?
Being scared of dying makes sense - that may involve pain or dementia - being scared of death is pretty pointless.