A public inquiry has uncovered "systematic abuse" and a "profound catalogue of failures" that left some of Northern Ireland's most vulnerable adults exposed to harm.