'Apocalyptic' storm front over Sydney