There are a lot of clubs that forbid alcohol in the US and Canada too.

Some of them are open for example only between 2am and 8am with a nice variety of other drugs available.

Clubs don't forbid alcohol. That was misleading hyperbole. Being visibly drunk at the door might reduce chances to get in, but clubs make a lot of money with drinks and the majority of people will buy drinks, even in clubs where illicit drugs are consumed.

Yeah, there are, or at least were, a few.

The thing about Berlin clubs is they care very strongly about the vibe and being cool, and/or protecting those deep in psychedlics or other stuff. Aggressive, drunk assholes ruin that so they are verboten in some spots. The bars are all happily stocked with non-alcoholic selections. It's not America where you need to make money at all costs fuck the consequences.

Note that these are the same places that will reputedly dump you out the back door if you overdo it or OD, take from that what you will.

Also, I think you underestimate just how much the party scene loves Club Mate over there. That is what we drank instead. It pairs really nicely with molly!