Police are combing through a crime scene after a man was shot four times and a Sydney home was sprayed with bullets in a night-time attack.