People get way too excited for any game, should always expect a pile of shit these days and just be pleasantly surprised instead. People are die hard fans of games like CP2077 before they even release, it's not good.
But expectations don't come from nowhere, a lot of the city stuff they were selling was like GTA, but the AI didn't even release at a 2004 San Andreas level, it's still not as good as GTA AI and that's just people walking/driving around convincingly. GTA V itself was 7 years old when CP2077 released, it's not surprising people were expecting a simulation of the world to be at least as good as that. I think their scope was too big, there was probs a lot of mismanagement behind the scenes. I don't know how they spent 8 years on it and it still turned out like it did, I guess we will never know what happened. The story is the only saving grace, they should have just delayed it and tried to make it a more linear story game and just abandon any RPG-esque/open world elements that were left.
Being critical of games is good, especially ones that completely shit the bed, defending it just leads to more of that in the future. I love BG3 for example, but it has it's fair share of issues that I can point out every time I play it. Why would I not want better products? Why settle for less? There's too much submissive consumerism these days.