One of Sydney’s most iconic sites has been destroyed after a “hazardous” and “scary” swell smashed parts of the city, causing widespread damage.