All games get to that point eventually.

I tend to alternate between Valheim and No Man's Sky, especially when NMS puts out a new update or runs an expedition which they do regularly. (They're doing the holiday expedition reruns now and it's probably on sale for half off considering the season.) (Nope not on sale, but it does it regularly.) NMS doesn't really have an end goal though. I just start new saves when I get in the mood and mess around a bit. Of course if unnecessary exploration bothers you, you won't like NMS either. It's a zillion times bigger than Valheim. But it is another game where it's easy to lose a few hundred hours.