Overdosing on drugs might be enjoyable in the short term, but it is bad in the long term - context is important.
Determining whether or not something is "good" or "bad" is often a matter of consensus, but even that isn't an ironclad and objective statement of reality, as it were. History of full of examples where the consensus for the longest time was bent in one direction and then, with new knowledge or simply a change in perspective, went in another entirely. Take your example of "Citizen Kane" from before - in its own time it was the subject of lukewarm reviews and largely languished in obscurity until it was reevaluated more than a decade later and slowly went on to become a film classic in our time. History is replete with modern classics that were largely hated in their own times, mutually disliked by the consensus of their day. Times change, and so do opinions (for better and for worse).