Cars trapped in extreme flooding on major Sydney thoroughfare