It depends.
A marijuana high seems a LOT less trouble-some than any kind of drunkeness.
But a coke high, crack high, ecstasy high or hallucinogenic drug high can be a traumatic affair for the doer and anyone that comes in contact with the doer.
Habitual drunks are intolerable, but weed-heads don't bother me much. They seem smarter when they're high.