I'm in Rochester, on the north side of the Detroit metro area. I may not qualify, however, as my Guzzis are of the older persuasion -- 1976, 1983 and 1986. I'm also not much of a bike night person. That being said, there are pretty active gatherings in Royal Oak. Wednesday's tend to be Harley-ish while Thursday's have more of a sport bike orientation. Guzzi riders will be equally out of place on either night.
You will find a greater mix of classics and less well-known brands and bikes in Ypsilanti in the Depot Town area on Tuesday nights. Depot Town in Ypsilanti is worth a daytime visit, too. You can stop by Cafe Racer, a motorcycle shop whose name is self-explanatory. It's nice to see a place working on classics where they don't feel the need to demonstrate their "craft" by showering angle grinder sparks throughout the shop. They do actual work. Then there's the last remaining Hudson dealership (genuine parts still in stock and Hudson automobiles on the floor), as well as the Orphan Car Museum. Not too far from there is a fire apparatus museum. Depot Town itself has an interesting restaurant scene in a sort of hip, urban context. Try The Wurst Bar for a wide range of brews and the odd sausage.
Send me a PM and we can see if our coordinates work out.