After all Paul said "to die is gain" which does'nt sound like he expected to sleep a couple of thousand years.
Well... our Lord used the term "sleep" in referring to death.
I agree with you that Paul didn't expect to sleep in death for over 2000 years. He expected Jesus to return, and thus his personal resurrection, in his own life time.
However, what practical difference does it make. Paul is dead, and not experiencing
anything. The next thing Paul will know is being alive in the resurrection. Upon his rising, Paul will not know whether he was dead for a year, 50 years, 2000 years, or 90000 years. He will know only if he is told.
The proof texts used to try to show immediate consciousness after death, in their contexts, deal with one's personal resurrection. Here are two examples:
Jesus said:
Mark 12:27 He is not the God of the dead, but of the living. You are badly mistaken! NIV
When we look at the context, we see that this is part of Jesus' answer to the Saducees who disbelieved in the
resurrection. Jesus was saying that if God is the God of Abraham, Isaac, and Jacob, they are not going to stay dead, for He is the God of the living.
And now for one that is not in the Bible, but has been misquoted for so long, that everyone thinks it is:
To be absent from the body is to be present with the Lord.
If that had been what Paul had written, that would pretty much settle it in favour of immediate consciousness after death.
Here is the entire passage --- again dealing with the resurrection:
2 Corinthians 5:1-8
51 Lo! I tell you a mystery. We shall not all sleep, but we shall all be changed,
52 in a moment, in the twinkling of an eye, at the last trumpet. For the trumpet will sound, and the dead will be raised imperishable, and we shall be changed.
]1 For we know that if the earthly tent we live in is destroyed, we have a building from God, a house not made with hands, eternal in the heavens.
Paul imagines living in the body to be analogous to living in a tent. So he calls our body our "earthly tent". He thinks of the resurrected body as a "heavenly building" which God prepares for us, a permanent structure.
2 Here indeed we groan, and long to put on our heavenly dwelling,
We can get pretty tired living in this decaying body. We long to have our permanent heavenly body.
3 so that by putting it on we may not be found naked.
When we die, we don't just lose our "earthly tent" and go to heaven as a disembodied spirit. In the resurrection, we will be raised imperishable.
4 For while we are still in this tent, we sigh with anxiety; not that we would be unclothed, but that we would be further clothed, so that what is mortal may be swallowed up by life.
Paul makes a similar statement in different words. Now he compares dying to "being unclothed" and being raised again as "being further clothed."
"Not that we would be unclothed" --- not that we would be disembodied.
"that what is mortal may be swallowed up by life," seems to be very similar language to "This mortal must put on immortality" I Cor 15:53. Paul wrote the latter statement in the context of the his teaching about our resurrection:
51 Lo! I tell you a secret. We shall not all sleep, but we shall all be changed, in a moment, in the twinkling of an eye, at the last trumpet. For the trumpet will sound, and the dead will be raised imperishable, and we shall be changed. I Cor 15:51,52
Continuing with 2 Corinthians 5:
5 He who has prepared us for this very thing is God, who has given us the Spirit as a guarantee.
6 So we are always of good courage; we know that while we are at home in the body we are away from the Lord,
7 for we walk by faith, not by sight.
As long as we live in this corruptible body, we are away from the Lord.
8 We are of good courage, and we would rather be away from the body and at home with the Lord.
Paul states that we would rather be absent from this present corruptible body and to be present with the Lord in the immortal body which we will receive when we are raised from death at the coming of the Lord.