Central or western NY would be closest to CT if you want proper lake effect snow. You need to be near a Great Lake. There’s only a few areas in the country that get snow like this.