No doubt drugs are a scourge in society but as you point out prohibition and higher penalties has failed to eliminate the problem. Its a very complex topic.
Given in NSW both major parties have continued with the medically supervised injecting rooms I can only assume that there must be significant benefits to having them.