I also live in Vancouver, typically travel to the US two or three times a year. For me the hassle of TSA, CBP and lousy airlines is a major deterrent and has definitely reduced the number of my visits by both land and air. The reason I go to the US is not because I want to, it's because there's no practical alternative most of the time. (There are no palm trees in Canada and I don't care for Mexico or Cuba!)
And I don't see it getting any better.