Nobody should ever lose complete control on oneself, being sober or net. If thats so, stay clean.
I don't think, any substance could make you do something that wasn't there in your personality before.
If you're prone to violence, you might go berserk when drunk --> stay away, If you're prone to brooding , you might go psycho when stoned --> stay away.
On the other hand, by tradition many cultures are encouraging the use of diverse substances, sometimes even as an initiation ritual to their adolescents.
Strangly, laws on substances vary from culture to culture.
Summary: having a glass of wine is different from having two bottles a day.
Smoking is unhealthy.