Complex question.
First let us first talk only about the physical side of it. Many causes can lead to death, you may die suddenly (car crash, deadly stroke etc), or it might be a very long process taking hours or even days (for example the end of a long ilness when you drift in and out of consciousness for days in a hospital).
But the main thing is at the end you will lose consciousness never to regain it. If you ever had a medical operation that required anesthesia you will have an idea what I mean. This should really be seen in a positive light - whatever fear, pain etc might have led up to this will be gone. Physically-wise that's how it ends for you. What happens to your remains is a problem for the state or your family, it won't be of concern to you.
If you do not believe in any form of a spiritual life after death, then what I described in the paragrah above will be all that you will get to experience as far as death goes. Loss of consciousness and never regaining it.
Now, if you do believe that there is some spiritual life after death, then here is where things can take drasticaly different turns. Philosophers, Theologians, Holy Men and Mystics have ben arguing about this since the dawn of civilization.
So as far as spirituality goes, you need to find an expert authority person of your religion and talk this over. This is a common theme for people to ask priests, rabbis, mullahs and other religious figures. Any figure of authority within your religion (if he has a good head on his shoulders that is, dumb people can be found in any job) will be familiar with the topic and will provide you with all necessary information as far as that religion goes.
You mentioned "eternal loneliness". This is how hell is described in "High Church Catholicism" (as opposed to folk-belief-catholicism where you would instead have fire, brimstone, tar and devils with horns).
That is one possibility as far as catholicism goes. There are two other ones:
Heaven, which "High Church Catholicism" will describe as being with God and participating in God. As God is the absolute entirety of creation (and more) this means that you will get to participate in everything and anything you like. The church will stress that it is a fulfilling, voluntary experience that takes place out of time itself.
I'm sorry if I oversimplified it a bit, Theologians tend to describe in in whole tomes, I wanted just a few sentences.
The third option is a transitory state nown as "Purgatory". This is a plae where you prepare, train and become purified so that you may go to heaven once you are ready. This is just a transitory place, as the ultimately everyone in purgatory will at some point become ready and go to Heaven. Old time Catholicism used to say that purgatory is a place of suffering (folk-catholicism sometimes still tends to do it), but modern "High Church Catholicism" will say that it is not necessarily the case. That this is more like athletes training for the olympics - it may be tiring or hard at times, but it is not torture in any way and it is all for an ultmate good goal.
That's how it works in Catholicism. For other religions, you need to talk with their own experts. I'm no priest, but I believe I'm well enough versed in the doctrine to offer this insight.