I've done this race multiple times and volunteered last year.
The bike isn't terrible -- the island is 5.5 miles around so you still get a bit of variety. The odd thing to get used to is that since it's a one-way course with traffic on your right, you pass on the right. The road conditions are hit or miss. They are currently preparing for the Detroit Grand Prix race (I was actually riding there last night!) a few weeks before Motor City, so there might still be some race blockades and debris laying around. I remember a few complaints from last year about potholes and broken bottles. The island is very flat so get ready to go fast, although you might get some decent wind from one end of the island or the other.
I volunteered last year because they were desperate for volunteers, so interpret that however you want. They pride themselves on being a safe, well-run race, and I was witness to several race-morning problems being solved. Their staff seemed to be knowledgeable -- I had both good and bad interactions with them behind the scenes. There are aspects of their race management that I would do differently, but I'm not a race manager, either.
Honestly I don't know that I would drive 4 hours for this race unless you already visiting family here or something. Unlike the Freep Marathon, you don't actually cross over (or swim to, haha) Canada, and the river can be a rough swim. I see the Grand Rapids Tri is two weeks earlier if you are just looking for a June race.
http://mediocremultisport.blogspot.com