I am not an addict, but I have went to different therapists over the years. I think CBT was the most successful for me in that I feel it really helped me to change the pathways in my brain leading to different ways of reacting and different ways of thinking. That's just me though.
There will be parts of therapy that will be hard no matter which way you choose, but coming out on the other side with different thinking is what was key for me. This type of therapy was also very successful for my young adult daughter.
It was expensive, however, it was also worth every single penny. You have to invest in your own wellbeing, and this changes you for life.
Just my two cents.