Earlier quoted context omitted.
Was Rome celebrating its ruins in 400AD? Surely there's some interesting things to celebrate, but a 50 year old crackhouse that's still occupied by crack addicts probably isn't one of them. What makes Rome's 'ruins' great is - well, probably a bunch of things - but certainly the longetivity is one of them. There's nothing impressive about rotting crack houses.
There are a few abandoned buildings in Detroit that might count as having grandeur, like: http://en.wikipedia.org/wiki/Michigan_Central_Station , http://en.wikipedia.org/wiki/Grand_Army_of_the_Republic_Buil... . I agree that acres of rotting single-family homes isn't so impressive.
Celebrate the beauty that exists (Michigan Central was actually what I was thinking of with the Rome comment) and take advantage of the rest. Do you know how cheap it is to live in the city? Yes: there are acres of abandoned rotting land, but what's keeping Detroit from turning it's warehouses into startups? Imagine SOMA on a city scale.