American Coney Island: The best (and first) coney island in the state of Michigan, but more specifically Detroit. :P
http://www.americanconeyisland.com/home.htm
ETA: In general, though, the hole-in-the-wall coneys are the best!
Unrelated, there's also great beer everywhere.