All I can say is RUN. I completely agree with SugarLily. As my therapist told me in a recent session, if you meet someone who isn't "complete", RUN. Don't let yourself believe that you are the one who can help him meet his potential. Only HE can do that. If you don't have children and are not married to him...RUN.
he truly is AMAZING...when he isn't under the influence
You don't want to live the rest of your life waiting for the few hours/mins of every day for him to be "amazing". You deserve so much more. He'll get himself together when he's ready...but that could be YEARS from now or maybe even never. Run while you still can!