Avon gets fun, it doesn't usually get good until the first couple lake effect storms. Cancer Cove needs a NW swell more so than the rest of the "breaks" in the area.
That being said, Huntington and Edgewater make for fun surf just about any time you have a sizable North wind for 15-20 hours.  
I just moved back to Ohio and know you can ski park... you have a board as well?