Robert McMuscles plays - and is very good at - pretty much every sport known to man, and couldn't get a girl to save his life.
Subverted: Seamus O'Taku loves anime, manga, comic books, Star Trek, and video games. But he also has a girlfriend or wife that he loves, and, yes, sleeps with.
Double Subverted: When he isn't too busy fantasizing about all those Moe Moe anime girls. He is way more attracted to the Moe Moe Bishoujo than he is to his real-life flesh-and-blood girlfriend or wife.
A jihadist arrives in Heaven, believing that he will be rewarded for his faith and efforts with 72 virgins. And he gets...72 Trekkies.
Seamus loves his nerdy hobbies more than anything. The second he loses his virginity, he immediately stops liking them, abandons them in favour of more "normal" hobbies like sports, devotes most of his waking hours to the pursuit of sex, and starts making fun of his nerdy former brethren; calling them sad, pathetic, no-life losers who need to get laid.
Seamus hires a prostitute, but it turns out that not even a whore is willing to sleep with him!
Seamus O'Taku participates in discussions about girls, but would rather ogle Moe Bishoujo at home.
Seamus is actually quite successful at attracting women and convincing them to come back to his home for sex, but the second they spot his game console or shelf full of comic books and action figures, they immediately turn around and walk out the door while laughing at him for being a nerd, so he has never actually had sex.
Seamus has no "geeky" interests whatsoever and is a Jerk Jock.
Seamus' geeky interests have no effect on his attractiveness whatsoever, negative or positive.
Enforced: "How about a story of the love life of a nerdy guy?" "What love life?"
Lampshaded: "Looks like another lonely night in playing Halo!"
Seamus O'Taku acts this way to drive off girls who wouldn't accept his interests and would bore him.
Seamus O'Taku is either gay, a victim of sexual abuse, or both, and he uses this to cover up his homosexuality or avoid being in any situation that reminds him of his abuse.
Exploited: An evil cult needs to perform several virgin sacrifices as part of an ancient ritual to gain great power; so they start abducting lots of nerds in order to get a steady supply of virgins.
Defied: Seamus O'Taku keeps himself interesting and sexy, even in spite of his "geeky" interests. He practices good social skills, and gets plenty of action regularly.
Discussed: "No, I'm not a virgin just because I'm a nerd! That doesn't even follow!"
Conversed: "Poor Seamus. He'll never get a girlfriend like that!" "It's so hard to get any if you like anime!"
Deconstructed: Seamus O'Taku has no interests that others (save for fellow nerds) can relate to, and feels alienated by the others (and they, likewise, feel alienated by him.) He then fixates on the geeky pursuits that give him comfort, resulting in further alienation and further comfort-seeking.
Seamus O'Taku still likes his anime, manga, video games, comic books, Star Trek etc. But develops other interests, and becomes a more well-rounded person. He also develops better social skills as he comes out of his shell. Eventually he meets a girl that he likes, and they have a happy, healthy relationship. (And, yes, sex.)
Alternatively: It turns out that Seamus' lack of sexual life isn't a consequence of his geeky-interests, but a life-style decision. He might be waiting for the right moment and / or person, or he might be not interested in it at all; however this situation doesn't have a negative impact at all on him, as he uses all the extra energy, time and resources he would spend "trying to get some" to do constructive things (like writing science fiction novels, or building robots) that are more fulfilling and satisfying to him.