Obviously haven't met you in person, but this is also really apparent just by reading your replies in this thread; not sure if you communicate in much the same way when you're 1-on-1 with people, but dude, you're kinda all over the place.

Regardless, the key to "confidence" in this sphere comes in one of two ways: it either comes to you naturally (which some peeps are naturally gifted with) or you have to learn what it takes to keep someone engaged. It sounds like you've tried "all the wrong things" so maybe try approaching it from a different angle.

This advice is gonna sound really douchey, but I highly recommend you at least give it a go. Download a book called magic bullets by nick savoy; also get the game by neil strauss. Even after throwing out all the PUA non-sense, it really focuses on the psychology of how to interact with people and better ways to make conversation interesting. That's really where "confidence" comes from IMO; once you hone an approach, you'll quickly figure out what works best given your natural personality and interests...this should most definitely, at least, lead you away from friendzone-type results.

If the above reading materials jive with you, maybe look into these bootcamps as well...given that you've got l00t and are quickly loosing hope, there's no reason not to at least try something this drastic given your current situation:
http://www.3secondrule.co.uk/portfolio/