If you won't have a car then Sherwood's is your only bet. It's right in Macomb. They have 'OK' beer. Sometimes can be hit and miss. If you go get a pizza with the bold and spicy beer sauce.
If you can drive I would recommend Kuhnhenn's and Dragonmead. They both have really good beer/mead and a huge selection of styles.
If you venture slightly further there are a couple more options: Griffin Claw in Birmingham just opened and are making some excellent beers. If like mead B. Nektar has a free tasting every Friday and Sat you could attend. If you like Belgian beers Bastone in Royal Oak is pretty good as well.
Those would