I came across this article which I did find pretty interesting.

However, I would still like to know how this would work in the case of substance abuse. I feel like there needs to be more clarity on this.

Here's the link. Maybe you all can check it out:

https://buddingpsychologists.org/applications-of-existential-therapy/