This is unsympathetically referred to as "ruin porn" around Detroit. Yes, there are an exceptional amount of abandoned buildings (there are about 600,000 people in a city that could probably comfortably hold 3x that), but there are also world class universities, sports arenas, restaurants concert venues, houses and apartments, etc.
http://www.viceland.com/int/v16n8/htdocs/something-something...