A lot of modern games overdo it with the story sequences, and I hate that but there's also some players who thinks story has no bearing at all on a game, and jrpgs would be better as visual novels, and also that cutscenes are a band aid or a flawed way of putting story in a game because you're putting it "aside" the game and it's not interactive. Many people also say "games have bad stories anyway"
I never agreed with that, I'm somehwere in the middle. I think a good game story is one that compliments the gameplay. A game story is bad if it gets in the way of the game instead of, like I said, Elevating it. And I vastly prefer doing it with cutscenes than boring ass voice overs.
A good cutscene is a good way to set the mood and feel of a game, wether be at the beginning with a nice intro (remember when games had openings?) or to introduce a battle sequence or a boss fight, or after the boss fight.
A perfect example is the introduction of Phantom in devil may cry, it catches you by surprise, it looks sick, and it shows the player dante's persopnality, how unphased he is by the biggest enemy you've encountered in this game; it's also a way the game tells you "you can do this, the main character doesnt see it as a thread".
Then when you finally defeat him after the third encounter, he seemed impossible but now you probably dispatched him easily, and now you're gonna feel as confident as Dante as he looks down at him and goes "Sweet Dreams". It introduces you to the character while also connecting him to the player, and it's a satisfying watch after he made you game over many times and you had to grind for the yellow orbs. It's not detatched from the game in this way.
Still going wtih dmc, the scene before level 1 gives you an idea of "this is how you're gonna have to play the game" without going into boring tutorials and while still leaving room for the player to bash his head against the wall and get good.
I also dont think cutscenes should be The Sole way a game shows his story, I think they should be made On Top of the story the player is already experiencing with the game play. A lot of ps2 horror do just that, cutscenes are reserved for either introducing bosses or new areas or characters, the bulk of the story is told byu the player exploring the maps and engaging with all the scares