Many people are saying to pursue other hobbies, and that the magic will come back on its own.
I think they have great advice, but it doesn't answer your question.
I have 3 suggestions: 1 hardware and 2 games, all of which are outside of your previous experience with games.
1: Get a steam deck. This device on it's own brought much of the childhood magic back into gaming, and i can't describe how it feels in text. Just get one.
2: Buy Wildfrost, which is currently my Best In Class pick for UI design and a tight gameplay loop
Bonus: It pairs really well with the steam deck
3: Get Factorio. I bought this back when it was $20, and it has more playtime than any other game i have. The mods available make the game fresh and new, and the base game is deeper than 99% of other games out there. This is the game that gave me the same feeling like BoTW, and as long as you find the gameplay fun it will be a permanent Favorites contender.