So.... you went to yahoo, and selected a few answers that reinforce your beliefs.

Other comments from the same site, when putting "nerdy socially awkward man" into the search came up with these (amongst others):

"First of all, don't generalize women based on some dumb show. I, and a lot of my friends, prefer nerdy guys for a few reasons:

1) They make the BEST lovers (maybe because they've had years to fantasize about sex, so when it happens--YOWZA!!

2) They are usually mature and not emotionally retarded like the pretty boys, and are great conversationalists.

3) Because they are not conventionally handsome, they make up for it with advanced education, successful careers, etc (paging Bill Gates!!)"

"It all depends.I don't think anyone wants a relationship with a "stupid person". I personally kinda like shy and nerdy guys, but I also like a guy who is confident. Really, it's all different, and I definetly don't really think about the genes"

"I have found that most women will give nerdy men the chance if they have sex appeal, attractiveness and confidence. Some women actually prefer nerdy men, but as you can tell, these women aren't too common or found almost everywhere.

Unfortunately, most nerds are introverted, socially awkward, unattractive, dislike partying or going out, which puts many young and hot women off.

Party girls are usually airheads that are extremely shallow and care very little about intelligence or substance in a man. They only care about attractiveness, and the stereotypical nerd isn't dubbed as the most attractive man on earth.

My boyfriend is extremely nerdy, introverted and shy. Despite being extremely nerdy by his likes and interests, he is very attractive and sexy."

"L, I am afraid that there is a lot for you to learn about women.

A beautiful woman who has class might actually, surprise surprise, want to date a man with brains. This might come as a shock to you, but there are some attractive women who actually enjoy the company of men who have an interesting world view and professional success.

Yes, they might have a bald spot, or say, thick glasses. They might also not have ripped pectoral muscles. But you know what? They have something interesting to say, and something worthwhile to contribute to the world.

They also, God forbid, might be men who are ethical and God-fearing, and loyal to their wives and mothers.

That is why you see attractive women with dorks. Trust me, it is not about the money."

"Haha I find the nerdy type attractive. But that's just me."

"Everyone will have their own opinion and nerdy isn't a bad thing. To me nerdy is smart and shy. I am not interested in star wars, but I play games on nintendo and the internet. My husband likes star wars. Every female will have their likes dislikes but it doesn't mean you have to have the same interests as they do and you can still be compatible."

"There are many women who do like nerdy men. I actually prefer them as a matter of fact! As long as you take care of yourself so that you look and smell good to a women, there is no reason for them not to like you. Nerdy men are usually very good and faithful in relationships, which tends to make women feel secure."

"My boyfriend reads big books and plays video games, and I like him way more than my ex who didn't read in his free time (and was also pretty dumb. Haha)
Just depends on your personality really."

....................

etc, etc, etc. You can find plenty on there to either work against, or for, your own prejudices and assumptions.

All of your posts treat women all the same - we're individuals, just like men. Each person has different criteria for what they find attractive. There are also plenty of socially awkward women who have the same frustrations that you do.

I don't think anyone considers bitterness to be an attractive trait though.