As an American, I think we're darn lucky to have them as a neighbor. It could have been worse. A lot worse. Just look around the world for examples of testy border relations. For that matter, look no further than the U.S.-Mexico border. All sorts of shenanigans go on down there, and in both directions.
So thanks for being a pal, Canada. :)
I also found this on Wikipedia:
Today there are close cultural ties, many similar and identical traits[13][14][15][16] and according to Gallup's annual public opinion polls, Canada has consistently been Americans' favorite nation, with 96% of Americans viewing Canada favorably in 2012.[17][18] According to a 2013 BBC World Service Poll, 84% of Americans view their northern neighbor's influence positively, with only 5% expressing a negative view, the most favorable perception of Canada in the world. As of spring 2013, 64% of Canadians had a favorable view of the U.S. and 81% expressed confidence in then-US President Obama to do the right thing in international matters. According to the same poll, 30% viewed the U.S. negatively.[19] Also, according to a 2014 BBC World Service Poll, 86% of Americans view Canada's influence positively, with only 5% expressing a negative view. However, according to the same poll, 43% of Canadians view U.S. influence positively, with 52% expressing a negative view.[20]
So we like them, but they just sort of tolerate us. Lol... Oh, well. Can't win 'em all, I guess. No hard feelings, though, guys. :D