Nice transition from Yakuza's zombie infestation to Raccoon City. I saw what you did there.
Half this list could have been made of GTA or Saint's Row cities.
Honestly, I can't think of a whole lot of video game cities I would want to visit. City 17 (Half-Life 2): dystopian hellhole. Midgar (Final Fantasy VII): polluted and mostly destroyed. Empire City (Infamous): trashed. Rapture (Bioshock series): yeah, no.
It was nice to see a shout-out to City of Villains. Good times.
City of Heroes had lots of these kinds of places. They had alternate realities where the Nazis won WW2.