The ancient Sanskrit Vedas go into a lot of detailed description of the creation and the structure of the material world, but much of it is also fantastical. They also go into the nature of the mind in quite an astute psychological way, so that can be helpful.
They also tell stories of the mystics who met the gods after long meditation, though those gods would be riding on winged eagles, or would send swan airplanes to fetch the mystics and take then to the next life. They also talk about wrathful or helpful angels who come to fetch the departing soul at death, depending on your karma. So there is plenty of info and some of it may be valid, yet no one can say for sure. And much of it sounds like fantasy, or may use cosmic time and distance that we cannot fathom, like millions of years.
There is also a future prediction in the Bhagavat Purana at the end, where one last avatar or incarnation of god will appear to wipe out the evil kings that control the earth, but they say he will only arrive in about half a million years from now, so don't hold your breath. From now until then it will keep getting worse on the planet, they say.
It does indeed seem rather sad to think that we are just the playthings of the gods who care very little about our suffering. But that's how it is portrayed in the Sanskrit texts. They say contradictory things too which can be difficult to reconcile, and hard to accept without a huge dose of magical thinking. They say that this material world is not false, but that it is temporary, while our real nature is eternal. Some others however, say it is all false, so it depends on which version of the Sanskrit Vedanta you choose to identify with. No clear and direct answers, only several different interpretations and philosophical conclusions, and according to which perspective of reality you choose to adopt, your actions are presumably affected accordingly, for better or worse.