The killing by Garda police of a depressed young man outside his County Longford home six years ago was unnecessary, the judge who carried out a two-year inquiry into the incident has said.