Annie is totally right. Everyone's family and the individuals within those famiies are different. My own birth family are about as dysfunctional as they could possibly be and that, particularly my mother, was something that I lamented for years.
All you can do is try to be close to people, you can't force them, and if they don't want to be as close as you do then that's just THEIR loss not yours. Took me a very long time to realise this, as I had a lot of trauma from my childhood, where my mother actively stood by and allowed my father to repeatedly beat the bejaysus out of me on a very regular basis until his death. She didn't want to make up for that, and nothing I can do or say will change that, but I do understand your dreams, because even now mine are very similar. However, I got married for the second time to a wonderful woman who led me away from considering that there was something wrong with me, which caused their reactions and although we are not still together it did make me realise that this was none of my fault.
It's given me the chance to move on to be who I really am and now I'm fairly happy with that.
Well done for kicking the booze as well, as a prop. I was previously many years ago addicted to drink and drugs because of my unhappiness, and you don't want to be there, so you've absolutely done the right thing.
As annie says, make yourself available to them, but don't place your happiness in other people's hands.