Berkshire Botanical Gardens have their Harvest Fests in October, it may be too far south for you, but the Stockbridge area is nice for a day trip.

Norman Rockwell museum is in Stockbridge.

Clark Museum has the Munch Exhibit this summer into October.

Check out Naumkaeg- not sure what is happening in Oct, but its beautiful

Then MassMoca