For the believer in the Lord Jesus it's a case of 'absent from the body...present with the Lord' (2 Corinthians 5.8).
Blessings.
Let's take this in context...
2Co 5:8 We are confident, I say, and willing rather to be absent from the body, and to be present with the Lord.
There is a big difference between "willing rather to be" and already there.
2Co 5:9 Wherefore we labour, that, whether present or absent, we may be accepted of him.
2Co 5:10 For we
must all appear before the judgment seat of Christ; that every one may receive the things done in his body, according to that he hath done, whether it be good or bad.
When is the judgment?
Mat 25:31 When the Son of man shall come in his glory, and all the holy angels with him, then shall he sit upon the throne of his glory:
Mat 25:32 And before him shall be gathered all nations: and he shall separate them one from another, as a shepherd divideth his sheep from the goats:
Mat 25:33 And he shall set the sheep on his right hand, but the goats on the left.
Mat 11:22 But I say unto you, It shall be more tolerable for Tyre and Sidon at the day of judgment, than for you.
This verse shows there is a day of judgment, but it has not yet come for Tyre and Sidon. Neither has it come for anyone dead. David is dead but has not been judged...
Act 2:29 Men and brethren, let me freely speak unto you of the patriarch David, that he is both dead and buried, and his sepulchre is with us unto this day.
Now David was a man after God's own heart, but we read this about him...
Act 2:34 For David is not ascended into the heavens: but he saith himself, The LORD said unto my Lord, Sit thou on my right hand,
We read this about those in the Hall of Fame...
Heb 11:13 These all died in faith, not having received the promises, but having seen them afar off, and were persuaded of them, and embraced them, and confessed that they were strangers and pilgrims on the earth.
There is a day coming for judgment, but not immediately upon death...
Mat 24:30 And then shall appear the sign of the Son of man in heaven: and then shall all the tribes of the earth mourn, and they shall see the Son of man coming in the clouds of heaven with power and great glory.
Mat 24:31 And he shall send his angels with a great sound of a trumpet, and they shall gather together his elect from the four winds, from one end of heaven to the other.
Mat 24:46 Blessed is that servant, whom his lord when he cometh shall find so doing.
Mat 24:47 Verily I say unto you, That he shall make him ruler over all his goods.
Mat 24:48 But and if that evil servant shall say in his heart, My lord delayeth his coming;
Mat 24:49 And shall begin to smite his fellowservants, and to eat and drink with the drunken;
Mat 24:50 The lord of that servant shall come in a day when he looketh not for him, and in an hour that he is not aware of,
Mat 24:51 And shall cut him asunder, and appoint him his portion with the hypocrites: there shall be weeping and gnashing of teeth.
Mat 25:19 After a long time the lord of those servants cometh, and reckoneth with them.
Mat 25:20 And so he that had received five talents came and brought other five talents, saying, Lord, thou deliveredst unto me five talents: behold, I have gained beside them five talents more.
Mat 25:21 His lord said unto him, Well done, thou good and faithful servant: thou hast been faithful over a few things, I will make thee ruler over many things: enter thou into the joy of thy lord.
Mat 25:22 He also that had received two talents came and said, Lord, thou deliveredst unto me two talents: behold, I have gained two other talents beside them.
Mat 25:23 His lord said unto him, Well done, good and faithful servant; thou hast been faithful over a few things, I will make thee ruler over many things: enter thou into the joy of thy lord.
Mat 25:24 Then he which had received the one talent came and said, Lord, I knew thee that thou art an hard man, reaping where thou hast not sown, and gathering where thou hast not strawed:
Mat 25:25 And I was afraid, and went and hid thy talent in the earth: lo, there thou hast that is thine.
Mat 25:26 His lord answered and said unto him, Thou wicked and slothful servant, thou knewest that I reap where I sowed not, and gather where I have not strawed:
Mat 25:27 Thou oughtest therefore to have put my money to the exchangers, and then at my coming I should have received mine own with usury.
Mat 25:28 Take therefore the talent from him, and give it unto him which hath ten talents.
Mat 25:29 For unto every one that hath shall be given, and he shall have abundance: but from him that hath not shall be taken away even that which he hath.
Mat 25:30 And cast ye the unprofitable servant into outer darkness: there shall be weeping and gnashing of teeth.