You’ll still need a work permit to work in Canada, even for a US company remotely. So hopefully you’re up to speed on that process. In terms of where to live, there are some places in BC outside major cities that are affordable. Might be worth taking a road trip around to check some out
Rainy on the coast but roads in the interior can get dicey if there’s snow. Stick to major highways.