A lead investigator into maternity scandals says the treatment of families failed by a Welsh hospital's maternity unit is "appalling".