The Silverdome is in Pontiac which is about a 30 minute drive from Detroit and the Lions moved out of there about 10 years ago so that's not too relevant to this topic.
Comerica Park, Ford Field, and Joe Louis Arena are actually in Detroit and they're all great facilities. Comerica Park and Ford Field are across the street from each other and both are state of the art. The area surrounding those 2 stadiums is one of the nicest parts of Detroit. Joe Louis is located on the water, a couple miles south of Comerica and Ford Field, and while it might be old, it still has a great atmosphere and is probably my favorite out of the 3.
Pretty incredible. Could've sold my house, bought that and turned the interior into a giant vegetable patch with some grazing land. A fattoria with stadium seating and reasonable exterior defenses against zombie hordes. Much more interesting than a house in the suburbs.
One of them sold for under $600,000 a couple years ago!
http://en.wikipedia.org/wiki/Silverdome#Sale