Water firms are leaving too many households feeling “let down and abandoned” after sewer flooding, according to a joint report from the regulator and watchdog.