That’s mostly the other side of shite infrastructure design. Things like this happen 1-2x per decade at least, and power grids should be designed to handle them. (Sandy was an outlier, since it hit during high tide, during a full moon — but not unprecedented either: look up the 1938 New England super-hurricane)