Whale Watching— worth it?

Same as the title, do you think whale watching is worth it? If so, do you recommend morning, afternoon, or sunset? I’m looking into Dolphin Fleet of Provincetown.

Side note: I have to take a motion sickness pill for car rides longer than a half hour… I know it’s weather dependent, but what could I expect with the boat and water conditions? Will they still take the boat out if it’s rougher water? What general tips do you have to be comfortable and have the best experience in general?