A man who allegedly threatened police with a knife is dead after officers opened fire at a home in suburban Adelaide.