So I'm new to Canada and just saw this news.
https://www.theweathernetwork .com/...ar-wind/72713/

Anyone familiar with Hamilton and surrounding areas know any good place to see this?

The princess point, Bayfront park and its surrounding areas. In fact there's plenty of public spots near Sarcoa Bar. Also I guess somewhere on the mountain where there's a good view over the city will work just as well.

Frankly, doubt you will see anything with this weather.

Yeah, it doesn't really matter where you go if there's cloud cover. It's just bad timing - there are three days we're supposed to be able to see them here, but it's cloudy all three days. Too bad, it's a pretty awesome sight!