I was an expat in the US for many years, the story was the same in the mid-90s. Many try it, some stay, some come back. I still work for a US company but moved back.
The current political climate has a big impact on encouraging people to stay in Canada, especially with NAFTA and the H1B programs hanging by a thread. Imagine thousands of Canadians with TN status getting told they need to move back immediately (More likely 30-60 days after a status change application) upon withdrawal from NAFTA. It will be a chaotic brain drain in reverse.
Amazon, Microsoft, Google all have large Canadian outposts lately for a reason.