Marvin's Marvelous Mechanical Museum in West Bloomfield at 14 Mile and Orchard Lake.
http://www.marvin3m.com/
Or there's Pinball Pete's in Ann Arbor, not sure of the cross roads as I have only been there one time.
Looks like the address from google is:
1214 S University Ave Ann Arbor, Michigan 48104 - (734) 213-2502
I would definitely hit Marvin's as there is some really crazy one of a kind and old stuff in there. Pinball Pete's is awesome too with about 15-20 pins and a row of classics.
I forgot about Tilt Town which just opened in Novi.
http://www.tilttown.com/
This is more of a members only type place, and I haven't joined yet, so I can give no feedback on it, but according to the website out of towners can get in for $10 and all the games are set to free play! Apparently this is off of 9 Mile and Novi rd in an unmarked industrial building, so I would definitely contact them before you go looking for that one.
Hope this gives you a good start.