I'm not sure if this is a success story exactly, but my social abilities have varied over the years. As a kid I had no skills, and was bullied badly in school. I was kind of ok with it because I didn't know anything else. Then I hit puberty and suddenly boys that had previously bullied me wanted to go out on dates with me. I couldn't handle the change, and withdrew completely forcing my parents to homeschool me.
I was totally alone for most of my teen years. Around 18 I decided to try socializing. I decided to try to look attractive since it seemed like the only time people were nice to me was because they liked how I looked. I didn't really know how to dress "like a girl" or how to wear make up, but I liked video games and anime so I tried to copy those characters. In hindsight I probably dressed in far too revealing a manner (shiny, tight, red, black, or blue vinyl, etc.), but it worked. Men were very nice to me. I wanted to talk to people that didn't fit in with mainstream society either, so I looked for social groups locally that seemed more accepting. I found a "goth" club and a coffee shop where people hung out at. Most of the people liked things like computers, science fiction, obscure movies and music, etc. I had a hard time talking to people at first, but as long as I was attractive people tended to be nice to me. Also they tended to drink, and then they wouldn't notice when I said stupid things or missed jokes, etc.
I started dating people, but I had a hard time making things work past about 6 months. I felt like I had to create a fake personality, and it would run out of steam by then. I really wish I'd not bothered to do that. I should have just been myself and risked rejection from the beginning instead of getting invested in the relationship first. Anyway, after about the 10th person I met someone like me, and we've been married almost 7 years now.
I made a couple really good friends at work that seemed very cut off from society as well. Even when single I found couples made better friends. I haven't seen them for a while now because I have kids and all my social energy is gone. I'm happy just hanging out with my husband though. I don't really need more people.
I weigh a little more now than I did before since having kids, and it's destroyed my social sense of self worth. I realize now that hiding behind my physical appearance socially was not the best plan.
So, to sum things up, I never got "good" at socializing, but I did find that if I found the right people and looked nice I could have lots of shallow friendships and date freely. I found a life partner by accident or luck, and a few good friends the same way. I don't think physical appearance was as important to everyone else as it was to me outside of my head, but it gave me a social buffer and confidence. Success? Probably not, lol. 