Personally there are a few games which left me very dissappointed, after hyping myself up for years in certain cases.
Divinity Original Sin: turns out I prefer more streamlined, less packed games (love Pillars of Eternity) and that coop play in a CRPG stresses me out.
Wasteland 2: I actually managed to finish this one but secretly I admit I was hoping for a better Fallout which I didn’t really get. New Vegas did the cowboy theme much better.
INSIDE: while the design was cool, it was just a ton of boring, easy puzzles in comparison to LIMBO, its predecessor.
Personally, a lot of the “content” in totk feels like busywork for me. With botw I didn’t know that to expect so I was willing to explore. But now, I know there’s only so many things I can find - a shrine or a korok seed. Totk just adds more of those tiny rewards (like bubblefrogs) and it just doesn’t feel worth it. At best, you sometimes get an armor piece but I barely even used any of those. There was one interesting side quest I found on the great plateau and I kept wondering what I would find, and it was just a heart container.
If any of the exploration lead to something other than a marginal reward, I think I’d enjoy my time a lot more. Maybe it’s just because I played outer wilds between the games, and find story to be a much more interesting thing to find than an item.