Years ago, maybe 90s, I recall watching a sci-fi movie or show where a friendly alien is stranded on Earth. If I recall correctly his alien buddies arrive to take him back. One of the earthlings is really eager to go with them, I think he was a scientist. So the aliens said sure you can tag along. As the spaceship takes off he talks to the aliens for a bit and then they tell him ok we're going for a nap, see ya. They enter hibernation chambers and he is left standing there looking out the window at the disappearing earth only to then realize his horrible mistake. He starts screaming but nobody is there to hear him. The aliens are already asleep and he is now stranded on the ship with god knows what waiting for him.
Does anyone recall this? Was it a Star Trek episode? Or something else? It must have been some obscure TV show.