I think some games have done it well when they have the character go through a tight space. Something like FFXVs narrow space walking is a bit clunky. But games like God of War or Uncharted do it well. Star Wars Jedi Fallen Order seems to be doing it. And you even get a funny little animation with the droid jumping over wires or whatever. It does not really take too much time.
I was into it for story reasons but then 5 min later you're fist fighting the last boss like nothing happened. What tf was the point then?? metal gear is the stupidest fucking shitBecause it came at the very end with no other such sequence (where you just mash one button) before or after, was not overtly long (like over 3 minutes), had something else going on for you to look at and was quite effective from a character standpoint. It really did feel like mashing one button to bring Snake to the bitter end after so much build-up and save your friends you saw dying in real time in the other cutscene window. The first time where you were quite immersed in the proceedings it was very effective. Helps such sequences weren't all that common yet in 2008.
Similar reason for TLoU, which was also scripted out very well to at least give additional illusion of dynamic gameplay during it. I can tolerate them if they serve the story, are scripted out well and the story happens to be interesting. 99% of times that's not the case, so they suck and are annoying