A man is dead after a drive-by shooting in south-west Sydney during the morning rush hour in what police called a targeted attack.