I am so sorry to hear your current situation.
Please know my words are not meant to cause you any further hurt , but the painful fact of the matter is there is nothing on this earth you can do to comfort him. Zeppelin , he currently doesn't want comfort , he wants his drug of choice.
The kind of help he needs, is an inside job, all the love, hugs, patience, and understanding is NOT going to help fix this for him.
He is a 27 year old man, he gets to choose for himself. He has to want to get sober, live sober, and stay sober.
Now if you want to entertain ways that you can comfort yourself, restore some normacly to your life, I believe you will find others willing to share their experience and personal stories here.
You are not alone, we have all walked in your shoes.