Vancouver is a notorious drug entry (and exit) point; I don't think Calgary is anywhere near as bad. YVR gets a lot of international passengers, YYC not so many.
Does this excuse agents (seemingly) not knowing the rules ? No, but remember they
do have a great deal of discretion on how (if?) they interpret and apply them.
But yeah, YVR is probably the worst Canadian airport for this kind of thing.