This rant that local diving is lousy/cold/low visibility/only for freaks is strange. You can hear the same arguments all around the globe, only exception being a few popular tourist diving sites. Maybe it is the industry to blame after all. OW course materials have only pictures of divers in sunny tropical locations and many dive shops promote dive travel more than local diving. This seems stupid. Local diving is often pretty good. People who dive all year round locally tend to support local shops and buy more gear.
DRIS (my shop) not only very actively promotes the local Great Lakes diving (one of the things they do is put any diver that wants it in a dry suit for the quarry checkout dives), but they have a growing charter op that actually gets you in the lake.
When a warm water diver is in the shop, I always make a point of chatting about how great the Great Lakes diving is and show wreck pics on my phone. I hope I've put the bug in the brain of at least several people.