Having grown up in western MA I'd highly recommend it. There are lots of small towns with back roads for biking. There's also loads of state forest land and great hiking, as the Appalachian Trail passes through the region. The ski mountains are smaller than those to the north, but they're fine for kids and the bigger ones are a short drive away. It's a bit less rugged and outdoorsy than ME, NH or VT but the schools are the best out of the lot if that's a concern for you.
It's also almost evenly centered between NYC and Boston if you want to do weekend city adventures. You'll probably still need a car but if you live in the center of town you won't use it except for longer trips.