Motorists were rescued from trapped cars and hundreds of houses were damaged after record levels of rainfall caused freak flash flooding across Dublin.