Welcome! Michigan is a wonderful state (four out of five Great Lakes agree
) I don't know specific spots as I only fished south of the bridge and just a bit north of Wisconsin. But hopefully someone will chime in. Also, don't pass up a chance to fish smallmouth in rivers. Not sure of spots near you, but if you find a wade-able river with smallies they are a blast.
If you haven't read the Nick Adams Stories
by Hemingway, you should. They are not only great stories but a good bit of them happen in the U.P and involve some fishing. However, the Big Two Hearted River that Nick fishes isn't the one you see on the map. It's the Fox and Seney is only about 1.5 hours from you. Never fished it but always wanted to when we crossed it on our way from the bridge to Northern Wisconsin.