Might be an unpopular take but the Red Dead Redemption 2 campaign. I’ve tried twice to start a second campaign but it’s so slow. The first time around the narrative carries it, so it doesn’t feel so slow. But knowing what happens next takes that away. The worst part is how ridged it is with mission failure/success conditions. It removes room for creative solutions.
This is not to say it wasn’t wonderful to play once. But it plays like they wanted to make a movie not a game.