The storm left Sydney’s public transport on its knees and roads inundated as more than 85 millimetres of rain fell in some parts of the city.