Knight Muzic basically said most of what I was planning to say in my reply

There may have been quite a number of 1960s/1970s rock bands who used drugs, but I don't think drugs were as prevalent with rock bands in the 1950s (unless it was under-reported).
~But then, in the '50s, doctors weren't as aware of the problems associated with drugs, so taking drugs wasn't considered a stigma at that time.
Sometimes, it's about perception.... I think actual cocaine used to be put into bottles of Coke soda pop, back in the late 19th century, but people back then didn't consider cocaine a 'bad' drug.
If I remember right, I think cocaine was actually touted as being a health benefit!
Back in the 1950s, cigarettes used to be advertised as being okay.
Timothy Leary became very influential around the 1960s, and I think he played a part in college students and rock stars abusing drugs. He popularized it or made it seem okay.
I don't think country music is known much for wide spread drug abuse.
The few cases I've heard were of singers (I think Johnny Cash was one) who had a legitimate problem (a physical injury), were prescribed pain killers by doctors, and then became hooked on the pain killers.
~This is opposed to druggie rock stars from the '60s onwards who took drugs to "get high," to feel buzzed.
It seems to me that most country singers have experienced problems with alcohol (e.g. George Jones, Hank Williams Sr), not cocaine, heroin, pot, etc.
As for artists who paint on canvas and who sculpt...
I believe Vincent Van Gogh abused some kind of drug (I don't remember which one).
Opium was apparently the drug of choice in the 19th century, but I'm not sure how many of the artists (or writers) used it.
Edgar Allen Poe had an alcohol problem, but I'm not sure if that contributed or took away from his writings.
I seriously doubt that most of the artists from the Renaissance (Leonardo, Michaelangelo, Raphael, etc) abused drugs - which to me is proof enough one doesn't have to use narcotics or medications to get good creative results.
I would guess that Mozart, Beethoven, Tchaikovsky, Handel, Bach, Chopin, etc. didn't abuse drugs.
I don't think it's the drugs/alcohol that brings about creativity.
To me, it's more like people have inborn, God-given talent, and then they happen to become drug or alcohol addicts.
Maybe creative types are more prone to use drugs than other sorts of people. Maybe they are more sensitive than average people, and they use the drugs to cope.
There seems to be a high percentage of homosexuals in the art community, and of left-handed people, too. I wouldn't argue that one has to be homosexual or left-handed to be talented or be creative.
It would be interesting to find out how many artists suffered from mental health issues, such as depression*.
I'd have to research the topic to find out how wide sperad drug abuse was among artists to give you a better answer.
*I just found this about
Beethoven:
Beethoven's personal life was troubled. His encroaching deafness led him to contemplate suicide (documented in his Heiligenstadt Testament). Beethoven was often irascible, and may have suffered from bipolar disorder,[15] and irritability brought on by chronic abdominal pain beginning in his 20s which has been attributed to his lead poisoning.
I also recall hearing somewhere that Handel contemplated suicide.
Obviously Vincent Van Gogh had some mental issues going on, too.