Hi there. I'm not in this boat, but professionally I'm in a related field.
Have you read "Being the other one: growing up with a brother or sister who has special needs" by Kate Strohm (2005)? There's nothing about substance abuse in it per se, but a lot of the stories would resonate with you.