Not to "debate" more, but you have to think of Freud in terms of his time period and culture. Back then, using cocaine was not seen as harmful, "deviant," or even unusual. It was very late in Freud's life that people started realizing the effects of cocaine.

-comfort the disturbed and disturb the comfortable-