Why wouldn't society want another narcotic causing more problems?
The thing is, society doesn't do drugs (or narcotics), individuals do. And society really doesn't have a legitimate say in what an individual does to him/her self. People are not obligated to be valuable to society and there are many legal ways in which an individual can make his or herself worthless to society. So, in short, it doesn't matter what "society" wants, as individual choice is primary. The limit to this individual choice is when the individual takes an action that directly harms another person, not some inferred harm caused by that person being worthless, and especially not based on some notion that the individual owes some degree of value to society.