Given the reciprocity and working relationship between the U.S. and Canada for intelligence and military matters, the policies are very much mirrored. The short answer is yes, recreational use of any drug ordinarily considered a controlled substance will preclude you from receiving a TS security clearance unless the use occurred many years ago and you can honestly say it was a mistake of immaturity at the time. More so than even a questionable credit and financial history, recent or current use of a recreational drug will preclude you from obtaining a clearance.
The logic is simple. If you can't be clean, professional and mature, then why should you be trusted with sensitive information that may be a matter of national security? If you're wanting a TS clearance, then you have to show you have your financial and lifestyle affairs in order because if you're granted a clearance, you're going to be expected to submit to routine drug testing and polygraphing as well as financial transparency (submission of your annual tax returns, bank statements and credit card statements). Those are regular items among employees and contractors working in a TS capacity for the government's interest.