Flash flooding has caused travel chaos in parts of England as thunderstorms dumped almost half a month's rain in some parts within hours.