So what is the appeal of diving in lakes, quarries, cold, low vis waters?
Is it just the thrill of the diving itself?
Is it the challenge presented by the conditions?
Maybe sometimes there is something interesting to see?
First things first: Lake, cold and low-viz can (and often are) connected but don't have to be.
Shallow diving in Swiss lakes gets quite warm in summer. Viz is pretty good during the winter and below a certain depth.
It's interesting, because we also have ~70 species you can find here. There are wrecks as well and the feeling of "flying" past an amazing wall that disappears into the darkness below you is exhilarating.
Here's a video from a lake dive.