Leading a life with substance abuse is never a good thing and may be dangerous.
Even if drugs or alcohol make a person feel happy when they're low it's not true happiness, it's just as a result of the substance altering your brain's natural way of thinking. It also doesn't tackle the true reason someone's low, either, only masks it.