Cars were filmed being swept away down a street which became a raging torrent during freak rain this week.