The best time to visit Cape Cod is May, June, September or October ... shoulder season is one of Cape Cod's best-kept secrets. Hotels drop their rates considerably as the tourists head home.