It sounds like you have a lot of the abilities and skills to be a back office, background type entrepreneur.
Your efforts to manage your mental illness goes a long way (for me, at least) towards your value. As a potential co-founder, I would appreciate the fact that you aren't a passive victim to your shortcomings -- you address them as best you can.
If your other skills were valuable to me as a co-founder, I would weigh those skills against your "shortcomings" WRT stability. Especially since you work at your shortcomings -- that would make me sympathize a bit. But more importantly, it reveals quite a bit about the quality of your character.
Now, on to the practical part: you still have to be a net positive for the startup. My personal bias is that having a programming co-founder is the single most important skill in a startup. The natural tendency for a coder is to have similar issues that you experience, even if less severe. Even if you're not being unfairly discounted due to your health issues, the problem is that you're unlikely to find a cofounder who can program AND is willing to be the business face.
And startups (in my limited experience) don't generally need IT / sysadmin co-founders. For my company (5 employees), we just use SaaS for any IT needs (dropbox, google apps, salesfoce, 37 signals). Combine that with our Mac setups, and your skillset isn't in great demand.
In conclusion, I first commend you for the efforts you put into combating your health problems. As a theoretical co-founder, I wouldn't be offset by those (it helps that I'm a middle ground type person, not really affected by daily highs and lows of a startup). However, the fact that your skillset is somewhat skewed (technical person who doesn't like approaching people and is also unable to code), I probably wouldn't be able to partner with you. I'm a coder who doesn't really like the face-to-face; it seems in my mind that you need to be one of those two personalities if you're going to fit in a startup with me specifically.
I wish you the best. My advice is that you continue working on your self-improvement, and that you really try to learn some programming. What languages have you attempted? If you can't do direct coding, then familiarize yourself with HTML or JS (frontend) stuff, or become an expert in analytics or email. There are always useful non-coding positions you can find; unfortunately, corporate style IT abilities are down on the list of useful skills.