We did this in 2016, went clockwise. Coming from Cleveland, here's where we stopped, and had a great time everywhere...Union Bay CG in the Porcupine Mountains, Michigan...Lamb's Resort, Schroeder, Minnesota....Happy Land CG in Thunder Bay, Ontario...Marathon, Ontario we had a reservation at a CG, but it was full when we arrived (they screwed up, we parked in a hotel lot)...Lake Superior Provincial Park, Agawa Bay section....Wilderness SP, Michigan (actually on Lake Michigan, at Straits of Mackinaw).
Absolutely loved the Agawa Bay CG, Union Bay, and Lamb's Resort. I'd rank the Happy Land CG last, but it wasn't awful. The Canadian side of Lake Superior isn't very populated, so make sure you fuel up wisely. I'm sure you'll enjoy this trip very much...good luck.