An investigation is underway into the fatal police shooting of a man in the backyard of his western Sydney home.