My wife and I rode the tidal bore when were visiting about 20 years ago. Basically, we were taken out in a zodiac/inflatable boat and the boat went down-river until we spotted the tidal bore, which looks like a 'ledge' of water, rolling up the river. The driver pulled the boat up on top of the tidal bore, and you cold look down on it. As it passes, the river gets a lot of waves, and we spent some time running over those - something that can be fun if you're not bothered by a rough ride.
Otherwise, we drove around the Cape Breton highlands, saw Peggy's Cove, Lunenberg, and went back to Halifax to meet up with some friends before flying home. It's a pretty place and we had a great time