I've been there. It's small, but cool. Several other people think so, too.

http://www.yelp.com/biz/painted-lady-lounge-hamtramck