Do I need a passport for a Hornblower cruise?

Yes, you need a valid passport (or other acceptable travel document) because the cruise departs from the Canadian side, and you need it just to get to the boarding dock. The requirement is about entering Canada, not the boat ride itself.