On the one hand sorcery is condemned in the OT, and presumably alchemy is a component of it. Likewise pharmacopia is said to be one of the forbidden bodies of knowledge given by the fallen angels in Apocrypha (altho this is open to speculation). Then on the other hand alcohol, its consumption and its production is permitted (even directly admired) by God throughout scripture. God chastises man, often very harshly, for drunkardism - while never blaming the actual substance. For God man is the problem not alchoal - Islam departs on this issue, placing evil itself in the substance. The scriptural attitude is that wine like all things is good and to be enjoyed in moderation, even to be moderately inebriated is something to be enjoyed - but alas, man in his fallen condition does not exert self control.
This attitude would presumably, extend to other herbs and substances - at least of similar potency (as so much of Gods view is concerned with loss of control). I think it fair to say that God would not be in favor of ingesting any substance of which the standard dose causes a person to enter a state of extreme inebriation or delirium. It is permissible to have some wine, or another such compound (im thinking of weed) - but if the standard/required dose is so potent as to seriously inhibit a persons capacities then it is not Gods will. Likewise anything that creates a fast tolerance/addiction is a problem. This is why think God is opposed to things such as meth, heroin, LSD and cocaine (yes even MDMA). Im not sure about chewing on coca leafs, khat or things like that - but im pretty sure the drugs i just mentioned are against Gods purposes for us entirely.