My wife and I rode a loop from Grosse Ile to Mackinaw City, and then south roughly following Lake Michigan to South Haven before turning east back to the start. We used a combination of roads and trails on our road/touring bikes without any problems. You have over 2800 miles of multi use trails in the state; most of them are easily ridden on a road bike. On another ride we stared from Grosse Ile and followed the Detroit River and Lake St Clair until we crossed into Canada at Algonac before heading to Toronto. My sister lives in Wyandotte.
Why the aversion to trails?
Crossing the River Rouge Bridge between Ecorse and River Rouge in 2019. We just took Jefferson Ave (Biddle) through Detroit. Detroit is really bike friendly
We did not realize it, but the an organized ride was going to ride across the Mackiinac Bridge the morning after we arrive in Mackinaw City. If we would have known, we would have joined them. Instead we dumped our gear at a motel, and took the ferry across to Mackinac Island.