I'm having the same issue. I search for "weather Stratford" and receive results for Connecticut instead of Stratford, Ontario. Similarly, if I search "weather waterloo", I get results for Austin, Texas instead of Waterloo, Ontario. Searching "weather Cambridge" returns Cambridgeshire, England.
I would expect it to use my location, or at the very least, my language preferences (Canadian English) to prioritize locations near me.