It depends upon the lake.
Right now Lake Michigan is really warm, 68 degrees down to 110', and the vis is only around 25'-30'.
I have been out there in January and measured out, with a fiberglass tape measure, 85' of horizontal vis. Of course, we have to shovel the snow off of the dock and dive in 35 degree water to get the good vis.
Inland lakes are another story.
Last night Ted and I went out to the Local lake (Lake Mendota) and "tried" to spearfish. I couldn't even see to the end of my 70cm. Rob Allen. I had to hold the butt down by my hip and try to shoot whatever might stumble upon me as I lay on the bottom.
I saw one fish, in an hour, and decided it just wasn't worth it to shoot the little bugger.
Last winter, in the exact same spot, I swear we hade close to 40' of vis. This winter I will take picutres to prove it.

On the bright side, last night we had 77 degree water to dive in and it felt really good to cool off in there from the 95 degree air temps that we had yesterday.
Here's a picture of a little better vis, in the summer time even.
Jon