None of the interpretations you quote are necessarily true. They're just cookbook astrology. Grossly oversimplified and often don't apply.
Scorpio Rising: I'm not sexy in the least and am really unattractive looking
Sexiness is in the eye of the beholder. How do you know you're not sexy? What makes you think you're ugly?
Afflicted Neptune in the first house: Probably one of the reasons I turned out ugly, but I don't have any drug or alcohol problems, though I do suffer from mental illness.
Neptune in the first could also give you wonderful creativity and intuitiveness, which would shine in your personality. Maybe have to be coaxed out of hiding a bit, since your Neptune is retrograde, but certainly present. Sagittarius is a very creative sign, too. Is the mental illness you suffer from bipolar disorder, by any chance? That would fit very well with that kind of Neptune/Sag picture. (Now I'm wondering if the Neptune in Sagittarius generation has more bipolars in it than others!)
Leo moon in the 10th house: I am not like a stereotypical Leo Moon at all. I hate attention and drama.
Not all Leos (solar, lunar, or anything else) like attention. Leo is like a cat. Some cats will approach anyone and demand to be petted. Others are very shy. But even shy cats usually like getting petted by one or two particular people. Similarly, Leo has an especially strong need for love, but not always adoring crowds. It can be as simple as one person saying I love you.
Even a tenth house Leo moon might not like attention or drama very much. If you're a "shy cat" kind of Leo moon, being in the spotlight is challenging for you, but you probably find yourself thrust into it anyway from time to time, at least in small ways. And you're probably someone people tend to remember. Leo people tend to take up space, unconsciously, and Scorpio people are typically memorable. Not always thought of as sexy--that's a misinterpretation--but memorable, which is sometimes interpreted as sexy.
Venus and Mars conjunct in the 8th house: again, I'm not sexy.
The eighth house doesn't have much to do with how you appear to others. It's one of the hidden houses. Venus and Mars in that house might give you a strong sex drive, or especially strong desire for intimacy--deep, unpretentious intimacy, that is. There are also many other ways those placements could manifest. Since you have them in Cancer, you might have an especially strong and protective nurturing instinct, or an especially strong desire to be nurtured. You probably operate from a deeply intuitive place when it comes to love, emotions, and interactions with others.
Jupiter in the second house: I am poor.
One out of every twelve people have Jupiter in the second house, and they run the gamut from 1%ers to beggars. Being poor is a circumstance, and it might change through your life. Perceiving yourself as poor, however, might be related to your Jupiter placement. Second house is all about personal security. Money is included in it because money spells material security, but it also means food, and emotional security, and body image, and health, and everything else you could think of that relates to security and personal values.
Jupiter is ordinarily very expansive and generous. Capricorn is ambitious and frugal and has a tendency to feel lacking. When Jupiter is in Capricorn, its expansiveness runs into Capricorn's barriers and tends to get pressed into service of Capricorn's sense of lack and desire for more.
You perceive yourself as poor (maybe you are; I don't know what your financial situation is; but plenty of people call themselves poor when they really are not), and you perceive yourself as ugly. Those are second house issues. Magnified by Jupiter and depressed by Capricorn.
Sun in the 7th house: I am socially awkward and avoid people.
You also have Saturn in the seventh house. That sometimes manifests as a loner tendency. Extreme loner tendency is social awkwardness and avoiding people.
Sun in the seventh house doesn't mean you're necessarily a gregarious person, it means that personal relationships are a key growth area for you, and key growth areas usually include noticeable conflict. Being socially awkward and avoiding people is one of those possible conflicts. Plus, Taurus can be very much a loner.
Uranus and Pluto in the 11th house: I don't have weird or controlling friends.
The way you described yourself in the rest of your post, it sounds like you don't have
any friends. If you do in fact have friends, being who you are, it's likely that there's something unusual about them. That doesn't necessarily mean they're weird, but they're probably people who tend to think out of the box and do whatever makes sense to them even if it's unconventional. Uranus in Libra, though, suggests some harmoniousness... very nice people who may be somewhat oddball but still get along well with others. And Pluto isn't always controlling. It has many other meanings....
Since your ascendant is Scorpio, Pluto is your chart ruler, along with Mars. Eleventh house doesn't actually mean friends in the modern sense of the word, people you like and have personal relationships with. Rather, it's the House of Friends in the archaic sense: people you associate with but don't necessarily have close personal relationships with. In modern English, that would more accurately be called associates.
If you have a mental illness, you've probably been closely associated with people who are also mentally ill. That, too, can be reflected by Pluto, as well as Uranus. Where Uranus is unconventionality, Pluto is the Underworld, hidden things, unacknowledged things... exactly what mental illness is in our society. Having your chart ruler in the eleventh house makes your associates another of the key growth areas for you. Really, relationships with others, and collaboration with others, is a key theme of your chart.
I have venus conjunct asc 1st I was always made fun of for being ugly or fat as a kid or as a young adult I remember this model girl saying to my mom...oh does she have trouble getting a bf.... I was practically engaged rofl and had sexy *** boyfriends.. She had trouble keeping a bf cuz she was a coked up balemic wreck. I just really love cake and cuddling. No amount of good genic combinations can make that less of a downer to be around..so yeah astrology is personal. Good luck! Ps also leo rising moon and I can go hide as soon as people come over. I like/need/flourish and go crazy without me time. I want to look right and feel right before facing others.
.