On the one hand I get where you're coming from, those sections are very thematically different from the rest of the game, but realistically it's just a couple of minutes of very easy stealth.
It's only bad when the game isn't a stealth game and also has shittastic stealth mechanics.
It's worse when it's the opposite, like Deus Ex: Human Revolution where the game is meant to be played in stealth, but then the boss battles are straight up FPS style shootouts when most players probably didn't put points into combat skills or armor because they're supposed to be a sneaky spy.
I honestly think the most egregious bullshit that has to do with stealth is Elden Ring and Sekiro. They have decent enough stealth mechanics, but they also have enemies that straight up don't give a fuck that you're in stealth so you're never actually able to sneak around the entire time. It's not that upsetting in ER, given it's not the intended method of play, but in Sekiro you're a literal god damn ninja who relies on being unseen. And iirc, Fromsoft also made Tenchu; one of the best stealth games of all time.
Unfortunately, FromSoft wasn't on Tenchu until later in the series when it...wasn't so great. Still, that Sekiro started as a Tenchu concept is why I picked up the game in the first place. And like Tenchu, effective stealth is there, it's just especially challenging.
Now, Zelda: Skyward Sword is one I can't defend (and one of the reasons I'm surprised OP is getting crushed for this post).
Any stealth game with a forced overt section should have a warning.
Examples:
Deus Ex: Human Revolution - Optional stealth game, but the boss battles just drop you in a room with the boss fully aware of you and that's the fight.
Assassin's Creed: Odyssey - Optional stealth, except for the battles for power where you can flip control of an area. No stealth allowed.
There's a danger in any game where it might be largely designed and marketed to be one thing, and then has lengthy mandatory sections where it becomes another.
Poorly made stealth sections are a prime example. Game designers want to change things up, but if the game isn't made to do stealth, it can easily turn into an annoying mess. There are a few (not a ton, but a few) games where the mandatory stealth sections are well liked, but they were made to carefully take advantage of the game's strengths and knew when to end.
There’s a danger in any game where it might be largely designed and marketed to be one thing, and then has lengthy mandatory sections where it becomes another.
This is the only issue I have with the cyberpunk 2077 DLC. Most of the game is an open-world action rpg. Then all of a sudden depending on your choices in the DLC you can end up in a mission that is basically Alien: Isolation survival horror. You go from being a powerhouse that can destroy pretty much anything in the game and shrug off missile hits to being hunted and unable to kill what is hunting you. It was super fucking annoying the first time I did the DLC because I hate those type of games. Great DLC except for that small part.
I blame Metroid Dread for that one. Such a bizarre design choice for Phantom Liberty, especially being very late in the game. At least Dread flipped that around.
It's a pet peeve of mine, I hate stealth sections. Waiting around just isn't fun and most stealth sections are just that.
However, that was years ago. I haven't encountered one in a long time since I mostly stopped playing AAA games - by now these games are an amalgamation of so many worse design decisions, I almost miss the time stealth sections were my biggest issue.