Beaches at Mentor-On-The-Lake start generating surf on NW, W, SW winds.

Headlands Beach State Park

Mentor Beach Park - I honestly don't see where exactly to surf there (maybe there is some other Metro Park in the area), I think the Yacht Club nearby is a better bet.

Overlook Beach Park

Edgewater Park Beach well-established surf spot in Cleveland, OH. The best waves build at breakwall and sewer pipe on strong NE, NW, and SW winds. Here is a comprehensive video on surfing in Cleveland, Ohio. Watch how surfing may look like at Edgewater Park Beach in the Summer, September, October

There are also some references to surfing in Euclid Park - but the sandy beach seem to be spoiled with the wave breakers. West outskirt looks promising though.

Well-established surf spot near Duluth MN. Featured #4 in The Best Places to Go Surfing on the Great Lakes along with Duluth, MN. Bunch of rocky and gravel spots along Stoney Point Dr . Large waves on NE. Check-out SToNeY PoiNT surfers' community on Facebook. See how surfing may look like at Stoney Point near Duluth MN on these youtube videos: August, October, February, Spring. Read article at Duluth Indian Point Campground.

The South shore of lake Michigan has plenty of surf spots along its miles and miles of sandy beaches. They work on winds from the North moving all length of lake Michigan water surface.

Ogden Dunes: West Beach - pounding waves on strong North winds. The beach has a bath house.

Dune Acres: Dune Acres Beach - community (parking can be limited), Porter Beach - parking and bathrooms

Beverly Shores, works best on NW winds: Indiana Dunes State Park - 3 miles of sand and shore breaks, Kemil Avenue Beach, Central Beach

Holland State Park - beautiful half mile sand beach. The surf kicks in on NW.

Tunnel Park - sandbar and shore break work reliably on N, NE, SW winds.

Presquile State Park - shore and sand breaks at Sunset Point and Beach #6 work on NW, W, SW winds. A little bit skeptical on Beach #6 because of wave breakers, but still, that is closest surf spot to Pittsburgh. Check this video by Ben Gravy for a good surf day in the past.

Freeport Beach - waves build along sand and pebble beach on NW, SW.

Considered one of the best surfing spots in Canada Kincardine beach . Waves often rise on NW, SW winds. You may also check Inverhuron Provincial Park beach North of Kincardine. Sandy beach should work well when winds are blowing from SW.

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.