Probably not what you want to hear but my best friend got pulled over for a DUI that was later reduced to Ability Impaired and he paid his fine and did the 2 classes he had to attend many years ago. I was in the car when he was pulled over. Small town bull as the cop and I had a previous run in and he was fired 3 years previously by the local PD for calling me a "cracker". Luckily the State Police were nice enough to hire him...
My friend went to Canada for work 3 times (all land crossings) with no problem. Then he got his random stop and they discovered the infraction. He was given paperwork and told he had to immediately leave and not return. They were polite (they are Canadian after all) but he has not been able to go for work or pleasure since.