IMO, the only thing that comes close to ToTK is BoTW

. Those two are basically in a class of their own, although aLttP is amazing and also similarly revolutionary considering it came out in 1991. I actually replayed the game recently, and was surprised at how many secrets and other hidden stuff there were in the Overworld...comparably OOT was practically empty.
The only non-Zelda Nintendo game, IMO, that is somewhat in the discussion would be Odyssey. Lots of puzzles/exploration and good balance between the two. But after that...

Even games like Metroid Prime (which was great) that are considered top 5 to 10 best Nintendo games ever made, depending on who you ask, isn't even in the ballpark
What really sets BOTW and TOTK apart, is that you can just go at your own pace. If you want to log a million hours in these games uncovering new stuff, then you can probably do it. But, if you want to go straight to the final boss with minimal time spent or just complete dungeons, divine beasts, etc you can do that too