It is clearly written in numerous sources in the Torah, Nach, Midrashim, meforshim, etc. that Hashem wants us to do good and if we listen to His Words He will bentch us in this world and we will earn Olam Haba in the next. As it says in Pirkei Avos: kol Yisroel yesh luhem chelek l’Olam Haba.
We were created to fufill our potential by doing good and we will get reward for it. And if we mess up there’s always the way to return with teshuva and our sins are forgiven.
Clearly, Hashem had in mind that we should benefit from the creation of the universe, not that we should rot in hell. I’m sure there are explanations for this particular Rasha.