Allow me to offer a suggestion: Instead of having the mindset that you always need "to find a co-founder, CEO type to move forward" (a very self-defeating and self-fulfilling idea, in the sense that having this mindset usually means people make no effort to improve themselves in this arena), why don't you try to generate an idea and then take this opportunity to learn sales/marketing/business skills. There's no inherent reason you can't try to improve your skills in those areas. There's no such thing as being to old to learn something new. And even if you find yourself lacking in social skills, many aspects of sales/marketing have nothing to do with sociability - internet marketing, cold-emailing etc.
Also read pg's essay on getting startup ideas, if you haven't already: http://paulgraham.com/startupideas.html