There's just levels to it.. for 1, whether cutscenes are skippable, and/or how long they are. Just in general how much time you are going to spend in the "cinematic" aspects of a game matters to someone like me, particularly how much you are forced to do it. Long walking / talking sections are the worst to me.
There's a couple of missions in Skyrim for instance I dread though, to your point. There's one where you accept an offer for a drink in a pub, and are transported to this other area with this joker-like character taunting you... shit bores me to tears, and I've only played it once, because my other 20 playthroughs I knew not to take that drink lol
But that type of "take you away from the core gameplay and force you to spend quite a bit of time doing something more 'cinematic' thing is few and far between compared to the hundreds of hours of content that is far less cinematic. Dialog trees are basically skippable cut-scenes in Skyrim for instance.
I greatly enjoyed Days Gone from Sony.. and it HAD those things, but I could also choose to fuck around for hours on end doing nothing cinematic at any given point as there's tons of content that doesn't revolve around boring shit like going on "dates" with your wife (zzzzzz). Some of the other forced "talking" sections you are on your bike... and I generally just enjoy mashing around on my bike in that game, even if it is on a relatively forced path.
Witcher is a good example of taking the cinematic thing too far for me... the part where suddenly you are Ciri and it's boring as shit for an hour for instance lol