Hi Pandora..
K.. lets look at this objectively..
You love your BF and he loves you.
Alcohol and drunken behaviour aside.. your relationship is good.
Your BF drinks to excess.
Your BF's excessive drinking causes/results in (for him): missed days at work; sleepwalking; inability to control his actions and a disregard for his physical well-being; physical injury.
Your BF's excessive drinking causes/results in (for you): worry, concern, hyper-vigilance; fear; sadness and tears; second guessing; a catalogue of pictures and videos of evidence of the consequences of the drinking.
Are the positives enough to outweigh the negatives? If yes, then stay. If no, then I suppose a change has to be made and that change has to come from you.. you are the only thing in this scenario you can control.
Only you know how it feels for you to be in this. Only you know how it feels for you to live this. Only you.. can know what is best for pandora. This all comes from you..
Tx