Famous private investigator Jack Palladino dies after being attacked in front of his home in San Francisco