I would look around Brewster or Orleans. It sort of depends on what sort of things you are looking to do. I have always had good luck with Tripadvisor for finding hotels and B&Bs. You can catch a ferry from Harwich to Nantucket which is a great day trip.
For what it is worth, Dr. Beach rated Coast Guard beach as seventh best beach in the US this year.