A public inquiry has uncovered "systematic abuse" and a "profound catalogue of failures" towards some of Northern Ireland's most vulnerable adults.