I loved Detroit when I was there. Definitely had that post-apocalyptic feel to it in the mornings, but it was still a cool place. Trying to find breakfast that wasn't $20 a head in the hotel was a little annoying, however.
Remember that people do live and work there. Yes, it might not be safe to walk around with a gold chain on your neck at midnight... but when I was there for DEMF, there was always a police presence and the streets seemed relatively safe to me.
Looking forward to going back there, hopefully for the SCP/UR Backpack Festival in August.