I had pretty realistic expectations about Cyberpunk. And I tried to warn people about it too, since I never saw CDPR going hard on game design. They never did in the past. I expected a bit more interactivity and consequences when it comes to conversations, since it felt like bread and butter of CDPR and a bit more developed city mechanics and physics, comparable to something like Watch Dogs, at least. So this is where I feel the game fell a bit short of my expectations. Everything else was pretty much what I expected to see - FPP Witcher 2-3 with cars. They can't beef up quests, but they can add new, they can improve mechanics and physics, add quality of life stuff if they play their cards right. So I'm looking forward to returning to CP77 once expansions and patches are out.
As for other games you listed, there were good even great games that I enjoyed, but CDPR just hits the closest to my home. Uncharted 4 + Lost Legacy, Resident Evil 2 remake, Final Fantasy 7 sequel, Metal Gear Solid V, Devil May Cry 5, Tekken 7, Detroit: Become Human, Nier: Automata etc.
What felt like real disappointments:
1) Resident Evil 3 remake. I hoped they will commit to make this game into something that feels less like expansion for Resident Evil 2, but they doubled down on it. The game isn't without positives, for example, I liked the characters of Jill and Carlos and their chemistry, evade move and overall visuals, but yeah... I wish it was more ambitious.
2) The Last of Us Parte Dos. This one feels like it did massive damage to the brand. Outside of being cheap, contrived, stupid and morose experience. It killed my interest almost completely. Insane graphics and sound, good performances are let down by writers.
3) Mankind Divided. The cast and writing are so dull, that I had almost no motivation to do anything in this game. The whole "aug lives matter" is so tone deaf and uninspired. Barely any improvement in gameplay over HR, which also felt like inferior DX1. Art direction is pretty cool, though.
And I'm listing only games which I looked forward to.