Generally, in cities you won’t have really any problems. My fiancee is Turkish and we live in the prairies and she’s never had anything happen. Folks stumble on her name sometimes but it’s not really racism.
If you go rural, you always up your chances of encountering more racism. Rural PEI/NB will be accidentally racist, rural AB/SK will not care if they’re racist. Generally this is true unless you’re camping/hiking, when you wrap back around to people who are generally just happy to see fellow outdoorsmen.
Much of North American racism isn’t from individual people but in systems. My fiancee’s experience is that European systems are more likely to be equitable but the people will be racist. In general, if you visit Canadian cities from Vancouver to Montreal, I wouldn’t expect you to have any racist encounters.
Most people are in favor, a minority aren’t. Population inversion should scare people more than it does, but right now the current dominant fear for people is housing costs, which immigration rates are being (very incorrectly) blamed for.
If you ask the average person, they probably would reply “immigration is fine as long as we can provide for everyone”. The average left-leaning person would be more likely to drop the conditional, and the average right leaning person would say “verb the noun” and ask why we’re letting immigrants take out 300k loans from banks and then leave the country with the cash[1].
It’s a mixed bag, as with anywhere.
[1] this is not happening in any meaningful capacity and most immigrants can’t secure any credit at all without collateral, but this is nonetheless a very real conversation I’ve had with a post-secondary educated semi-friend who really should know better