St. Alphonsus recommended all prayers through Mary.  Story goes:  St. Alphonsus preached 'All Through Mary"  and those that were at rock bottom in their agonies did this.  And they were happier for it.  Other saints fasted and sacrificed for their parishioners such as St. Cure of Ars.  St. Charles Borromeo, with results.

"Oh Jesus, through the Immaculate Heart of Mary, I offer you all my prayers, works, joys and  sufferings of this day.  For all the intentions of thy Most Sacred Heart.  In Union with the Holy Sacrifice of the Mass, throughout the world. In reparation for our sins and for all of our associates, and in particular for all the intentions of this month...(and whatever you like).

The little book of St Gertrude, Love, Joy and Peace is very good in directions/guidance in how to suffer, offer up sufferings. their value and etc.

Infallible prayer;

http://www.thesacredheart.com/shwound.htm


Story of Ven. Matt Talbot

http://www.matttalbot.ie/index.htm

Matt Talbot was a drunk in a world of hard drinking Dublin dockers who became an example of sobriety and faith to his co-workers and the people. I will offer my prayers too.

Marlelar - The Mercedarians and Trinitarians were two Orders whose work was the ransom of Christian captives kept by the Moslems.  Two of the Saints involved were St. Peter Nolasco and St. John of Matha.  Nowadays the Novus Ordo version of these orders claim for their work the assisting of drug addicts in throwing off their addition - the imprisonment of addiction.  Just a suggestion that these saints may, notwithstanding the current modern version of their orders, be sympathetic to the plight you describe and be willing to help with their prayers.  

From the little book; Trustful Surrender to Divine Providence

We do not ask enough

It is clear then that we do not receive anything because we do not ask enough. God could not give us little, He could not restrict His liberality to small things without doing us grave harm. Do not misunderstand me. I am not saying that we offend God if we ask for temporal benefits or to be freed from misfortune. Obviously prayers of this kind can rightly be addressed to Him by making the condition that they are not contrary to His glory or our eternal salvation. But as it is hardly likely that it would redound to His glory for Him to answer them, or to our advantage to have them answered if our wishes end there, it must be repeated that as long as we are content with little we run the risk of obtaining nothing.

Let me show you a good way to ask for happiness even in this world. It is a way that will oblige God to listen to you. [For example] Say to him earnestly:  Either give me so much money that my heart will be satisfied, or inspire me with such contempt for it that I no longer want it.

[I changed some of the words from the book in an attempt to adjust the prayer to your specific need. Perhaps you can customize it better for your particular need. Here is the prayer to be prayed often.......]

Either free my husband from alcohol, or make his addiction and everything that goes with it so pleasant for me that I would not exchange it for all the peace in the world. Either take away my suffering, or -- which would be to your greater glory -- change it into delight for me, and instead of causing me affliction, let it become a source of joy. You can take away the burden of my cross, or you can leave it with me without my feeling its weight. You can extinguish the fire that burns me, or you can let it burn in such a way that it refreshes me as it did the three youths in the fiery furnace. I ask you for either one thing or the other. What does it matter in what way I am happy? If I am happy through the marriage to an alcoholic husband, it is you I have to thank. If I am happy when deprived of all the troubles he brings, it gives you greater glory and my thanks are all the greater.