Three-year inquiry described police inaction over abuse as a 'shocking failure'