Port Huron can be a good time. Lots of bars and restaurants within a short walk.
Lexington can be a real happening place, definitely get a reservation. If you go during their art fair you are guaranteed to have a lot of people in port.
Been to Algonac Harbour Club many times; it's OK, has a decent pool and outdoor patio, good clean bathrooms and showers. But aside from a mile or so walk to Catch 22, there aren't other restaurants/bars nearby. If you do stay here and are want to go by boat to a decent Italian restaurant, I can provide info to get you there.
St Clair is a state park harbor. Nice facilities, and several bars / restaurants within a reasonable walk. There is also a great variety in the cost / quality equation, with both local dives and upper scale dining. The kids working the place can also drive you if you need to travel further or have someone with mobility challenges. The boardwalk along the river is beautiful, there is often music provided. If you bring a dinghy, you can run up the river many miles if you're careful. Also, if you're traveling with a group you can rent (for a small fee) one of the shelters, if you want to get together in the evening
As a kid, my parents exposed me to vacationing on the Lakes. My kids wanted other activities, so now that they're out of the house it's my wife and I, and we've started with 2 week trips into Lake Huron and Lake Michigan. Can't wait to see what Lake Erie offers these days. If you've got a handful of "go to's" down there, let's hear about them!