A family road trip to Niagara Falls, Canada, is one of those bucket-list adventures that lives up to every bit of the hype.