Cyberpunk was considered a "failure" due to bugs not the story.
It was considered a failure because it was buggy and it was missing a ton of stuff they advertised on.
And yes, the story of CP2077 was garbage as well, but it wasn't why the overall product sucked.