Residents along Sydney’s Botany Bay have woken to water in buildings, after a king tide combined with a storm surge to smash into coastal areas.