Agree with above. I guess you could say that colder water = better vis on average, but by no means is that universal. I was diving up on Cape Ann (30 miles north of Boston) this past Sunday....water temp was 41F....but vis was about 2-3 feet....and sometimes 0-1. We only did one dive since the vis was so poor. No fish life seen.....but with that vis, not much of anything was seen ;-)
Average summer vis is about 15 feet I would guess....affected by the usual variables of in-shore/off-shore, recent rain/storms, etc., etc. That said, there are lots of great photo ops (agree with macro comments above) and diving in New England!
Here is some footage from this past year (late September 2011) - gives you some idea of typical local conditions. This was on a charter boat trip out of Cape Ann. Not the greatest quality (particularly the initial footage at about 70 feet with no video light), but gives you some idea of what I would call "typical" vis. The video includes a mix of still pictures and video footage taken over these 2 dives (all taken with a Canon G11 in a Canon housing....using only the internal camera flash with no strobe). I was using a Halcyon EOS LED canister light.....not the most effective video light because of its strength.
Also note that some of the very best New England diving is in eastern ME (Eastport)...the downside being there are huge tides, making diving only possible 2x per day around slack tide. Also - not much dive infrastructure up there. The huge tide variations bring lots of nutrients through the water...growing huge, beautiful anemones and plant life.
Hope this helps.
Chris
Click on the image to start the video
