LOTR is always mentioned in these threads. Rightfully so. It is an amazing game. But it’s not because Valinor is out there and you’ll never see it. It’s because the modes and mini wizard modes you do see are fantastic.
What you’re probably looking for is a game that you’re not going to finish easily, and has a bunch of different stuff to do. Fortunately, most games made in the last 10 years fit that description.