I was in Detroit for the GLI this season, and if it wasn't for the friends that I got to hang out with, it would have sucked, big time.
Right after the hockey game, we went to Hockeytown to eat (makes sense, right?), it was closed. Yeah, that makes sense.
I wasn't impressed with the bars, yeah, they were there, but it just didn't seem like there was much happening at them. Granted this should be better for the Frozen 4, but it didn't make a good impression on me.
We were at Greektown, at about 1AM, right after the people mover stopped, the hotel was about 5 blocks away. We asked the security guard at the casino if he thought it was safe to walk back to the hotel, his response "I wouldn't walk that and I live here". We got a cab to go 5 blocks.
From my personal experience, only a couple months ago, I have no motivation to go back there. I probably will at some point, for the same reason I did this time, to meet up with and hang out with friends I haven't seen in a while.
One positive note about Detroit. We went to a little bar, not in downtown, one night, called the Cadieux Cafe (sp?). They had "feather bowling", which was awesome. The best I can describe it was curling, but with a dirt lane and a wheel of cheese. I highly recommend checking it out. Also, the mussels at the place were damm good as well. Call ahead to try to get a reservation to feather bowl, they said they are usually very busy.