A catastrophic hail storm in Sydney on Thursday is set to be the most expensive weather event of the year, with major insurers projecting costs in the hundreds of millions.