Still think there are more obvious choices in their catalog. "Nobody Home" springs to mind.

Syd inspired them, sure, but DSOTM is pretty universal - I think Roger said the concept was "pressures of modern life" and that's how they started putting ideas together.

I mean songs that fulfill the OP's request of having drug references. There are songs about dying, about flying, about money, about mental illness, about war, but about drugs?

Marillion - He Knows You Know

Status Quo - What You're Proposing ("I might be runny nosin'"), Living on an Island ("we're gonna get high")

ZZ Top - Brown Sugar

Muddy Waters - Champagne & Reefer

Not really. What song do you think is?

Cold Turkey

Happiness is a Warm Gun

Since you like Roadhouse Blues, give the Status Quo cover a try. Especially the live version with the jig in the middle.

Styles is as old as Bieber, both were teen stars but Styles seems to have increased his appeal whereas I haven't heard much from Bieber recently.

The Weeknd is a bit older but didn't get famous (at least in Germany) until later than Bieber.

The Weeknd? Harry Styles?

This is why Marillion - pioneers of crowdfunding and having their own label - are now making more money than when they were really famous - the contracts in the 80s were so shitty that they took years to repay the money EMI fronted them.