I dont recall Freud ever proposing any sort of legitimate psychological/psychoanalytical use for cocaine, such as those which are currently conducted in the Netherlands using MDMA and also those which were suggested by Jung in the early 1960s involving LSD. in the end, it really just seems that he liked the stuff, which is fine, many many people do.
of course, me myself, I'm with Pato sayin
"I do not snort the coke I only smoke sensimilla!"