I just finished my first playthrough as a nomad and it took me about 150 hours, so you can say I have spent a lot of time in Night City. In general I have enjoyed the game, even though as a base PS4 player the experience has been quite rocky to say the least.
My first wtf moment wasn't actually a disappointment, but just a weird moment where I realised there are a lot of dildos in the game. I mean, if you start the game as a nomad, and if you explore the first area, there's basically a dildo around each corner and behind every dumpster. I don't have anything against dildos, but damn those nomads are a horny bunch of people
My first actual minor disappointment was, that you couldn't destroy any walls after the prologue. Why make it possible there and not anywhere else? Kinda weird.
However, in the end I have to say, that at least for me the game is a great cyberpunk game and I'm looking forward for every new patch, dlc and other added content. My next playthrough will be as a corpo.