Hey Joe,
the blue diamond lounge is close by. I've never been there but I hear theres good action. Here is the info on it:
Blue Diamond Lounge
Address: 2453 Campbell St, Detroit, MI 48209
Phone
313) 842-9725
Also the ball cue and brew is in Lincoln Park, not far to the south, info:
Ball & Cue & Brew Billiards and Pro Shop 3434 Fort St, Lincoln Park, MI
hall of fame and plush pockets have already been mentioned, all are suppose to be pretty good places but I've only been to a couple of them.
If your north of Detroit there is a bunch of other places, I'm about an hour and a half north of Detroit, if your that far north your welcome to play at my house for free. You can PM me if you need any other info, How long are you in town for?
Tom