It is why I consider excessive use of cutscenes a tell of poor game design, They stop the machine and pull the player out of the environment. They have their place, but generally should be avoided.
book: tell a story
movie: show, don't tell (big sin opening lore dump)
game: do, don't show (big sin cutscene)
To the exception of TOTK, I _never_ noticed any link (hehe) between different titles. I know there are some references, but I never catch them.
Even Majora's Mask, which is an official follow up occurring months after Ocarina of Time have a totally different story to tell that don't even try to continue the OoT story and is more just another completely independent story barely in the same universe.
I love the Zelda games, I consider myself a fan. But they are just that : good games. Each of those games do have interesting stories to tell, interesting universes to visit, but the overall "franchise" lore is totally uninteresting.
And honestly I don't think it's something bad, it means each game is free to go where it wants, and every game is free to have an universe as rich as it wants.
I see Zelda totally like I see mario : it's just universe codes, not a real lore. Nobody cares if Mario Galaxy happens before or after Mario 64 or Super Mario World. Zelda is the same for me. And that's cool.
From what I understand - it's because Nintendo famously designs the game and gameplay systems first and then writes a story to match what they built. If the story doesn't work with the setting then...<shrug> - it's still a good game at the end of the day.
That's a very cynical and dare I say Hackernews take. You could also, less cynically, see them as unique pieces of art that have managed to carve a space in a field where, by necessity, a lot of money is needed to create it (AAA games).
Tears of the Kingdom is art. It's a beautiful, simple fairytale told through the medium of a huge open world game and there's something unique in being able to embody that story for so many hours. I haven't played any other Zelda games from the past ~20 years but if they're similarly artful (and by all accounts they are) we don't need to be cynical towards their simplicity or the fact that they're variations on a theme. Pretty much all human art (and business) is, after all.