Gourmet Marketing's study said that Mayflower Beach, located in Dennis on Cape Cod Bay, is the second-best beach in the country for beautiful sunsets.