From a purely architectural point of view i think you’d be hard pressed to find a better video game city than Night City. Scale too, like you mentioned. I always hold Paris in AC: Unity in really high regard too, but Cyberpunk is on another level in terms of complexity and verticality.
I think some buildings are actual 1:1 scale as well, which helps. I know the majority is 4:1, but at least Notre Dame is 1:1 if i remember right.