In the short run, some cash strapped homeowners that can't pay for repairs may be willing to sell at a discount for homes that require substantial CAPEX. I don't see valuations changing that much due to the thaw.
The more interesting question to me is the long run, and whether events like this are tied to climate change. With climate change these "once in a century" events will become far more frequent. Investments to improve the grid and adapt to a changing environment will be made, and costs of living will necessarily rise to pay for it. It's worth considering how that will change affordability and desirability in 20-30 years time for extreme colds and heats.
If climate change is a thing, and it does cause human migration on a large scale, what is very cheap now that won't be in the future? Cleveland, Detroit, Duluth and the whole upper Mid West have access to fresh water and won't have the same humidity heat events as the growing SE US. With a view towards the long term, I'm very interested in a strategy that can generate yield today in some of those markets, with opportunity for generational wealth levels of appreciation in 20-30 years.