I don't agree with this.
This is true for some cases, yes. But it's just as common if not more common for people to take drugs to mask pain. It's not about the drug being fun, but about the overwhelming pain of life being temporarily numbed.
Some drugs start off as fun before becoming something more severe. Others are never fun - they're just coping mechanisms.