Not to fan any flames or stoke any controversies.... and I haven't been to Canada since the 1970's and have no plans to go any time soon.... But can people who have recently been to Canada say, if they even routinely ask the question, "have you ever been arrested?". I mean sure they 'could' ask you and they 'could' pull your arrest record up on their computer. But is it front and center as part of their ordinary border inspection, or is even asking the question or checking an arrest record reserved for cases where the officer sees something else that compels them to dig a little deeper or perhaps some secondary inspection.
It seems plausible that the vast majority of American drunks who visit Canada are legitimately unaware of Canada's restriction, they just are not asked on an ordinary entry, ignorance is bliss, and their trips are uneventful. And perhaps it's a much much smaller number "don't look right" or something, get looked at a little closer and asked some extra questions and have issues.
All just pure speculation on my part. Like I say. Haven't been to Canada since the 1970's.