To be frank, I think most people are discontent. It's the human condition. I see this on a personal level, but there seem to be some polls to back it up [0]. It seems like being discontent could have evolutionary benefit (always reaching for more rather than stagnating).
There might be several different forms of discontent; and that they seem the same to us, but are not very similar underneath. For example, the girl who bing-eats ice cream after her boyfriend breaks up with her is clearly not doing something that would be healthy on a regular basis.
This might be vaguely like physical exercise, where a small amount is good for you, but too much causes your body to break.
I think you're right to categorize discontent or 'hireath' as pretty universal.
But the problem is the dichotomy. Even if you find meaning in the acid trip, you can't ever rationally explain that meaning, even to yourself. You know it happened, but that's all.
I suspect this to be the case. It seems to me that the a key feature with psychedelic drug users and proponents is that they end up discontent with life [1] (and to a degree, with reality). They're often talking about how these drugs helped them see some sort of truths, but as far as I can tell, these truths don't help them interact with reality.
[1] There's a good chance they actually just started out this way and I'm seeing a selection bias.