In their defense...do think they really wanted the best and most immersive "world"/city ever made in a game. I doubt they went at it with ill intent to start with, though the advertising toward the end ended up overselling way too much and overall peoples expectations were way too high...and some of that is on CDP
Though right in middle of the game, kinda close to release really...covid. Yeah I know its an excuse used by a lot of companies, but a lot of times it actually is a rather legit one. I don't imagine that helped things what so ever.
The entire predication of CDPR's marketing campaign and overall philosophy they claimed that would be the centerpiece of the game, was the fact that Night City was going to be the main driving point of the game. That it was going to be biggest part of Cyberpunk 2077, even over the main and side quests/stories of the game itself. They strictly ADVERTISED that it was going to be a decade turning, industry turning game, that would have this immersive reactive-dynamic city.
Of course as we all known by now, it was entirely hogwash essentially. It barely, if not at all, had much of the elements they claimed was going to be in Cyberpunk 2077. The only thing that they admittedly delivered on, was the city design itself... but that's only style and not substance. All the high aesthetic, but the city still feels essentially dead.
They've been making the game since 2012, which is 8 years. San Andreas only took 3 years to make. But which one has more developed game environments? CDPR was the one that stoked this hype, for a long time even. People trusted them and had high expectations of them due to the Witcher series. The company has nobody to blame but itself, so it isn't a "some" situation at all.
The biggest argument for this game at this point, is its "story".. Once you complete the game however, is it really worth it for any replay value? It seems like a Mafia 2 situation, where you finish it and never return back to it, because you already know the story that went on. That's not to say linear style games don't have a semblance of replayability for some people. But Cyberpunk 2077 puts up an illusion that its not a linear game, when it is. This overall makes the quality of game more low when taking into account the horrible AI, the fact that you can't actually modify your character with cybernetics, can't customize your vehicles, non-existent miscellaneous activities, etc.
Story alone, Cyberpunk 2077's isn't that good, if we're taking its reality as a linear style Action RPG into effect. It didn't really touch on its theme, where V slowly gains would-be notoriety around Night City doing various tasks and criminal feats. Instead it is completely skimmed over by a montage, cheating the player to experience such a thing; basically, all around bad pacing. No interaction with any of the gangs, beside them just being shooting gallery targets from time-to-time. The entirety of the story is more or less the story of Johnny Silverhand, than anything else. That character alone was most of Cyberpunk 2077's marketing with Keeanu Reeves and what not with the hype generation.
You never get any real connection with V at all throughout the game. They just feel like a set piece, and that's it. This is essentially due in part with how a major part of the player relation with V, that could've been developed, was skimmed over like mentioned previously. Even baring the skimmage though, all the choices you make with V barely matter and have no weight in developing them narratively. They just seem.. so dry compared to the likes of Geralt or Commander Shepard in the vein of these action RPGs with these type of protagonists that are crafted-designed for you. Hell, I even have to give props to Fallout 4 even though I don't like the game and hated the fact they added in a voiced protagonist; the Sole Survivor is a hell of a lot more compelling and personable than V as a character.
Storywise as a matter of fact... I think even Fallout 4's story is much more provoking and at least somewhat more dynamic than Cyberpunk 2077's story when looking at both of them... and that's just sad, considering the majority of the Fallout fandom agrees Fallout 4's story wasn't even good.
I feel like the only real draw to Cyberpunk from the majority of the people that like it, is merely due to its graphics and the minutiae seeming of the "Cyberpunk" aesthetic in the game alone; not to mention its major push in marketing to the mainstream at large. It doesn't give much substance beyond that, like I broached on earlier about, however.