I think there is some memorable side content, and I don’t think there are too many main story sequences that are that bad. However, I agree with you that a fundamental problem no patch could fix is that the story CDPR wanted to tell marries really poorly with an open-world RPG. It’s often immersion breaking and it frequently messes up the pacing.
It almost feels like they felt pressured into including an open world from outside expectations when what they really wanted to make was a linear, cinematic action game.