First, entering the US is a courtesy extended by the people of the United States to citizens of other countries. In doing so, the US reserves the right to "screen" people for suitability. We, as Canadians, have no inherent right to enter.
As regards the case highlighted by the video/audio it is clear that the initial officer wanted a confrontation based on the the flow of the conversation. The second customs officer inside the building was pretty patient, but by that point the Canadian guy had started being the "ugly" Canadian who acts like he doesn't have to follow the rules and directives because he is Canadian.
I had to laugh when the US agent said that they intercept 3 terrorists per day trying to enter the US! Not clear whether he meant via Niagara Falls or the entire country. Sounds like BS to me, if it was that high they might as well pack up and close the borders completely.
Bottom line, any time you are dealing with US authorities you should do EXACTLY what you are told. They all carry guns and don't seem to be shy about using them. If things go south, keep your mouth shut and tell them you wish to speak to a Canadian diplomat as soon as possible.
Oh, and I doubt this guy and his wife will ever be permitted to enter the US again!