Most men don't destroy your belongings or need anti-psychotic medication. So I guess that depends upon how you rate men in general. Do you go to every session, do you listen in to make sure he mentions the things that happened the week prior? Or, are you merely taking his word on it?
When you have two heavily damaged people in a relationship, it's usually codependent. You two are both by your own admission, heavily damaged. Your complete and utter defense of him is admirable, but misplaced as you're pretty much incapable of being objective about the situation due to your own situation.
I have absolutely nothing invested in whether you two succeed as a couple, or not. So why would I bother to write something unless I genuinely wanted to help.
I studied to be a psychologist before deciding I'd rather not deal with really broken people on a daily basis. While I still have an ongoing interest in the area, mostly I just do a lot of listening to people with serious problems. If you do it often enough what you hear is everyone is the exception to the rule according to them, and that the same patterns play out with people over and over again. That change, real change, takes pain and time to accomplish. Otherwise it's temporary. Even then, you'll relapse. The idea is that you'll relapse less and less over time via continuation of the healing process.
Pretty much you posted here asking for advice and thoughts, but anyone who posts something that you disagree with you immediately dismiss as not being the case rather than objectively thinking about it and asking additional questions. At this point your mind seems made up about a path to pursue, would you care to share what that is?
Do the research, add up the math, you'll see that there's a pretty good chance that I'm actually right. I'm just skipping over details on how I get through my thought process.
His behavior towards you, from what you've told us, is belligerent and growing violent. I'm guessing he yelled some very not-so-nice things at you during his big meltdown. Sure, he has issues that exacerbate the problem, but it's still his issue to deal with, and his choice to own up to his bad behavior and fix it or not.
It is good that you care about him, and are sticking by him. Just be careful about what you will and will not tolerate from him behavior wise. Make sure that he knows up front without reservation exactly how ****ed the situation is, and where he stands in your life.
Anyway, I wish you the best of luck in finding further help for you and your partner. Stay safe, and remember that in the end that the only person who can take care of you, is you. Others can support, but you're the one who has to own your life and your decisions in a deliberate manner.
"Well, then," the Cat went on, "you see a dog growls when it's angry, and wags its tail when it's pleased. Now I growl when I'm pleased, and wag my tail when I'm angry. Therefore I'm mad."