Detroit city is gross. Downtown looks like what shinerbock said earlier "an abandoned junkyard" Abandoned buildings, boarded up houses, and vacant/burned out lots galore. The suburbs are as good as any other though. Its sad but the city isn't going about rebuilding Detroit properly. Downtown sports can't save a city.
Other cities I wouldn't wan't to live in are Buffalo, Memphis, and Milwaukee.