Yet another good place on lake Erie Canadian shore. Check out the Pier at Port Stanley Beach: waves may come at sand bar on SW, SE winds. I'd also have a look at the small sandy beach at Main St. exit, the satellite photo shows some wrinkles coming to the shore.

City of Sandusky, Ohio , USA has surf spots on Cedar Point down to Nickel Plate Beach close to Huron, OH. Looks like Sheldon Marsh State Nature Preserve and small beach at Bay Point Marina & Resort might work too. The spots are supposed to work on strong NE winds.

There more than one surf spot in Port Colborne, ON area going off on SW winds.
Nickel Beach provides rolling shore break.
Wyldewood Beach - ideal for shortboarding.