Why would they be interested in attending the presidential inauguration if they were vehemently opposed to Trump?

The American border guards did the right thing. Their job is to protect Americans, not Canadians. 

Why do some Canadians think they have the right to travel into foreign countries and do anything they like?  The reality is, they don't.  If you travel to another country you have to respect that country and its politics.