There are too few good urban environments in video games.
They can be gorgeously detailed levels that have signage, graffiti, bars and shops, highway traffic, garbage, and other decorations that give it an organic feel but they also don't let you explore very much of it and are over before you know it and your next level is in a completely different environment.
They can also be boring. They can also be barren, either as bland corridors or labyrinths where everything looks the same and one can get frustrated trying to find a way out.
Worse yet, they can be theme parks with levels rigidly defined around one specific motif like Hospital Land, Wharf Land, Garden Land, or Science Lab Land.
Most games with memorable cities are guilty of the first attribute and include Resident Evil 2, Final Fantasy 7, and beat-em-ups like the Double Dragon games; even Bioshock is guilty of this by having an introductory level that feels like an organic city before it shoves you into its rigid theme park structure (but at least it was more memorable and felt a little more like a city than Bioshock Infinite's Columbia).
The only good urban environment I've ever come across was Resident Evil 3 because the entire game is a lovingly detailed city that you spend exploring in; it's immersive enough to give the impression that you're really in a city.
I would be grateful to know if there are more games like it.