Saw the Hipgnosis doco Squaring the Circle a month or so ago. Was directed by Anton Corbijn who was a photographer for NME back in the day before turning his hand to directing music videos and later films (including Control which was a pretty good movie about Ian Curtis).Check out The Art of Tripping by Storm Thurgeson. Covers off on the historical relationship between artists and drugs.
I reckon you’d dig it.