Flood-relief pilot projects have overrun by millions of euro, with some still incomplete almost a decade after they were due to finish, it has been revealed.