While making generalizations is inherently difficult given the scope of modern popular music, trends in terms of specific drugs have long existed.
In terms of a specific personal example, social activist and musician Linda McCartney is known for publicly remarked that she considered marijuana "pretty lightweight" while finding harder drugs to be "disgusting".