As others have stated here this is a very interesting thread. As an inland small boat operator I've been "pulled over" numerous times mostly to check fishing licences, tackle, life jackets, etc and I've never had a negative encounter BUT I've seen plenty stoopid $chitt azz boaters doing plenty of stoopid $chitt azz things so I'm glad that law enforcement is out there....yes, thank you for your service!
Here's an interesting but truly sad case of a canoe BUI conviction in Ontario:
https://nationalpost.com/news/in-a-case-that-made-canadian-legal-history-ontario-man-convicted-of-impaired-operation-of-a-canoe