Thousands of householders, business people and travellers suffered disruption after almost a month’s worth of rain fell within hours, raising fresh concerns that not enough was being spent on flood