The Hudson River Valley can be quite spectacular and can areas in Connecticut like Litchfield County.
As I understand it ... the best color follows a hard freeze for about a day