Flood-hit residents of Sydney have returned to their properties to assess the damage after downpour wreak havoc across NSW.