There is definitely an undercurrent of anger/disappointment towards the USA and Americans, but it's nowhere near the point of being hostile towards American visitors. No one is going to be chasing you out with pitchforks. Parts of the Island (and Victoria in particular) have big tourism industries and would be more than happy to have you spend your money and support local Canadian businesses.
The other comments have touched on it, but I think a couple of things to be aware of are 1) be polite/respectful, and 2) leave politics at the door. From your post, you're obviously not a Trump supporter, but I think it applies to both sides. Obviously we don't want to hear people talking about 51st state bullshit or wearing MAGA hats, but I think Canadians are equally tired of the "sorry about Trump" sentiment as well.
Hope you have a good trip! Sproat Lake is an amazing spot. You just missed them moving the Martin Mars bombers!
