Not sure if this person will “speak” to you or not, but I do like this woman’s articles and videos on personality disorders, core issues/ unmet needs, sitting with your own pain, etc. I’m not sure if she has any on substance abusers specifically, but she has plenty on emotionally unavailable / personality disordered partners, and why people choose them, so I personally have found them to be helpful and have some interesting info:
https://youtu.be/yGZswQHaNfk