I spent a weekend in late November on the Cape a couple years back (staying down in Provincetown). It's definitely very quiet and a much different experience from the typical Cape Cod trip. May be a bit strange for a first-ever visit.