First time visitor - where to go?

First time visiting Detroit in early September. What should I do/see while I'm there? Where are the gay areas of the city?