Of course there is Lelouch Lamperouge, who has many characters, such as Shirley, Kallen, and Milly vying for his affection, along with pretty much every girl in his school. Lelouch, however, is a Celibate Hero who doesn't have the time for romance. Instead, he focuses on winning a war for his little sister. The only reason we know he's not a Chaste Hero is because of that one time he asked Kallen to "comfort" him.
Vegeta from Dragon Ball Z seems a lot like this. We know he's not completely celibate because he fathered two children over the course of the series, but he otherwise comes across as someone who wouldn't be particularly interested in sex, his fixation being primarily on being stronger than Goku.
Played with in Slayers in regards to Zelgadis Graywords; in the anime, due to some Flanderization, he possibly falls under the "love is a distraction" excuse (as ship teasing with Princess Amelia demonstrates, he feels awkward around her at times). In the original novels, however, it's a completely different matter, as Zel mentions at one point that if he ever were to become intimate with a woman, he would hurt her severely because of his rock skin (which also implies that he may not be a virgin). He opposes raping Lina Inverse in the first novel because of this, as opposed to a more awkward reaction that his anime counterpart would probably have. Word of God mentions his intimacy issues in an interview.
Train Hartnett of Black Cat has a severe tendency toward this: he gets grossed out by the idea of posing as the pretty Rinslet's husband, whacks Kyoko when she tries to kiss him, and in the anime he puts a cat in front of his face so Kyoko kisses the kitty instead of him. Even with Saya, it's made clear that he only thought of her as a very close friend. He's also totally uninterested in men, much to Creed's dismay.
Shinji Ikari of Neon Genesis Evangelion shrinks from any and all potential relationships, romantic or not, because it's just too painful and frightening for him. This eventually makes him snap in End of Evangelion, when he declares that since "Nobody loves [him], they should all just die."
Somewhat subverted in the fact that he was in love with Asuka or at the very least romantically attracted to her, just too afraid of her and of attachment to pursue a relationship with her.
And it's not like he has any good choices in the relationship department - while he has mutual chemistry with both the girls he works with, they both are bags of issues potentially even worse than him.
Light Yagami, the Villain Protagonist of Death Note doesn't seem to desire sex or romance (though he fits both "Love is a Distraction," given his obsession with the Death Note and "Love is Beneath Me," due to blatant narcissism), and treats his Love InterestMisa quite coldly. He is fully aware of such matters, and uses the very idea of sexuality for his own benefit — pretending to read porn, supposedly unaware, in front of many security cameras designed to determine his likelihood of being Kira to ward off suspicion. Basically, Light only has sex if it benefits him. Would he have sex with a man if it would benefit him? Maybe not probable, but at least possible. Still, he would feel absolutely no passion about it, and wouldn't hesitate to burn the guy alive if it helps to further his goals. To him, hissexappeal is a tactic — he's quite possibly incapable of feeling 'love' or 'desire' in a romantic sense.
Even when Light plays a truly spectacular Memory Gambit and temporarily turns good, his feelings for Misa are still unclear. He is clearly concerned for her safety, and treats her much more warmly, but since this change applies to the way he treats everyone, it need not suggest real "love". Of course, even if he wanted to progress their relationship further, being handcuffed to L 24/7 would make it somewhat difficult.
L also deserves mention. Although he reacts more positively to Misa's kiss on the cheek than Light does, he probably views love and even meaningful friendship as something of a distraction. This is complicated further by his awkwardness.Word of God notes that Near and Mello were originally intended to be L's sons — but there's nothing in the plotline or the interviews with the creators that suggest they stuck with the idea.
Despite not being "heroes" per se, Shinigami are indispensable to the plot; they are neither permitted nor capable of sexual relationships with one another or with humans, so their celibacy is somewhat mandatory. Woe betide the shinigami that develops feelings for a human, no matter how platonic...
Kagemori Mamoru of Kage Kara Mamoru!, he believes that "Love is A Distraction" mainly because the girl that he is assigned to is so dimwitted at times that she would not survive without his constant protection and that going out with a girl would detract from his duty. His parents, on the other hand would argue, that Mamoru also has a special duty to find a girlfriend so he can get married and give them some grandchildren so the family tradition can be carried on.
Female examples: Both Mai and Natsuki from the Mai-HiME anime fall under the "Love is a Distraction" header (Mai because she's got a part-time job and has to take care of her younger brother Takumi, and Natsuki because she's consumed with thoughts of revenge against The Organization that indirectly killed her mother), so they spend much of their time ignoring or otherwise actively avoiding their love interests. After the audience finds out what happens to the first couple who openly declares their love, you can't really blame 'em.
And Mai gets the guy in the end, while Word of God says that Natsuki and Shizuru also get together eventually.
Gai Shishioh/Cyborg Guy from GaoGaiGar arguably qualifies. On the one hand, he has a girlfriend, on the other, he's just a head attached to a walking weapon, so it's not like they could do much.
Well, who knows what the cyborg body can do.
Note that at the end of the TV series Guy gets a body after purifying Zonuda/Mikoto, something which she seems very, very happy about. Take that as you will.
Allen Walker from D.Gray-Man: He is kissed (on the lips, even!) and hugged by Road Kamelot, who makes it very clear she has a crush on him, but he seems to only regard it as a nuisance, choosing to ignore it (the fact that Road stabbed him in the eye the last time he saw her might have something to do with it). He also chooses to ignore Rohfa's feelings for him, and in numerous occasions, even shows skepticism and signs of being unnerved by it. And in a "character interview" omake, his status as being a Celibate Hero is pretty much confirmed by Word of God, as he vehemently denies having a girlfriend or liking anyone, and that he's too focused and busy with his work to do anything like that.
Considering his past it's not hard to find out why he is chaste.
Taikoubou AKA Fukki from Houshin Engi: He never shows any romantic interest in any of the female (or male) characters. It probably didn't help that the only female character that was chasing him was an incredibly hideous monster. And it probably didn't help that he was actually an ancient alien.
Another female: Rei Hino/Mars from the Sailor Moon manga. This actually comes both from her Defrosting Ice Queen background and her past life in the Silver Millennium, where her past self made an oath of chastity to Princess Serenity.
In a way, it could also be said for all of Serenity's guardians, as they all promised total dedication to her, that not even love would separate them. In the manga at least...
Vash from Trigun is. Especially in the manga. He fakes being passed out in order to avoid the "favors" of prostitutes, spends an inordinate amount of his free time thinking about his dead mother figure, doesn't want any woman to see his scars and avoids any kind of romantic or sexual relationship, be it with Luida, Meryl or Jessica.
Mikuru Asahina from Suzumiya Haruhi No Yuutsu. It's not just about Haruhi unconsciously using her powers out of jealousy if Mikuru gets close to Kyon, but Mikuru is actually a Time Traveler who is not allowed to have a relationship with someone outside of her own time frame, per obvious work reasons.
In the first book, Haruhi says that while she is a "healthy young woman, after all," she doesn't have time for sex, what with trying to find the people right in front of her.
Sanzo in Saiyuki displays no sexual interest or preferences, despite both the anime and manga going out of the way to show that he breaks every other vow he had to take as a Buddhist priest. Wordof God says that he does, indeed, maintain his vow of celibacy, not out of consideration for his Buddhist beliefs (he has none, despite his job) but because he dislikes being touched in "that way". In the Burial arc of the manga, it's shown that the first people he ever killed intended to rape him, and it's implied this wasn't an uncommon occurrence in his life, with his physical attractiveness inviting a lot of creepy attention. Sanzo rarely allows anyone to touch him at all, with varying levels of exception for his traveling companions, especially Goku.
Samurai Gun. Ichimatsu is a regular customer of local Hooker with a Heart of Gold Ohana, but his "business" with her is strictly the non-sexual services provided. He's not unaware of her own romantic attraction to him, and isn't exactly unattracted to her himself, but he has ...issues with sex, due to the fact that, as a child, he was forced to watch his elder sister be raped and then murdered. He later learns that the one who did the deed was actually a servant of the same council of freedom fighters that he serves as a Samurai Gun; apparently, deliberately traumatising children so as to create recruits for the project was a deliberate tactic of theirs, to both make them "availible", give them a way to control them, and to start their Training from Hell.
More or less everyone from One Piece except characters like Sanji. Word of God is that 'They're in love with adventure' and notably Luffy can be seen ignoring Hancock's affections to the extent that he feels exactly 0 attraction for her, rendering her ability unable to affect him. Characters will occasionally act perverted, though.
Dr. Kenzo Tenma of Monster, after he saves the life of a boy over the city mayor - in defiance of the hospital director's orders. It's a mixture of Love Is A Distraction and I'm A Danger Magnet, as his life takes a very different turn after that fateful decision.
Nina Foertner/Anna Liebert is the same way and for the same reasons. She's far too busy hunting down her psychopathic brother to give a damn about romance. That said, she and Tenma do have one or two Ship Tease moments that may avert this.
Taito Magatsu from Blade of the Immortal, despite being attractive and having several female characters display an interest in him, makes a point to avoid any kind of relationship. The girl he shares a bed with even comes out and asks him why he's never tried anything with her, and others have teased him about his lacking sex life. Most put it down to his dead little sister.
In Fushigi Yuugi, the priestesses are required to maintain their virginity in order to summon the gods.
Kyouko from Skip Beat!, of the "bad past experiences" variety. She not only avoids love, she even convinces herself she's incapable of it. When confronted by romantic hints, she doesn't see the romance at all, but usually interprets it as some interestingly twisted scenario completely unrelated to love.
The titular character of Vampire Hunter D, particularly pronounced in the old 1985 OAV. In the novel it was based on he and the Girl of the Week actually get to first base but are interrupted, and at the end of the book he very pointedly moves on before things go any farther. In subsequent novels girls throw themselves at him right and left, but he pretty much ignores them. This is presumably due to a combination of his need for blood as a dhampir (half vampire) and "Love is A Distraction".
While Hayate the Combat Butler Hayate falls more on the Chaste Hero side of the line, when he is approached by Ayumu about her crush, or rather, later when approached by the student trio, he thinks he's unworthy of her love because of Athena's teaching him that he had to be financially able to support a girlfriend.
Toward the Terra takes this trope to its extreme conclusion. Even the thought of intimate relationships doesn't seem to exist in the same universe as Soldier Blue or the next Soldier (title for the leader of the Mu), Jomy. Interestingly, Tony has a girlfriend... but she obligatorily dies a few episodes before he becomes Jomy's replacement. Odd considering that they need all the psionic power they can get, Authority Equals Asskicking, and power is a function of genetics.
Edward Elric of Fullmetal Alchemist, for "distraction" reasons, since he has to get his brother's body back first until the very end, that is.
He stays like that throughout the 2003 anime adaptation though. Several potential love interests appear but, Ship Tease aside, his main focus is always his brother.
In the light novels, it is implied that Firo Prochainezo from Baccano! is one temporarily, although it is because the woman he is in love with is asexual. They do eventually get married... fifty years later.
Which in a case of Fridge Logic would have solved the entire quest: Knowing that she's everything Wagnard still lacks to perform his ritual to end the world and that she can't hide and run from him forever, Neese instead tries to stop him before he captures her. However, she's only the substitute sacrifice since her mother isn't a virgin anymore. If they got together, all problems would have been solved.
Actually, that would have only been a temporary solution. If Neese lost her virginity then the soul of Naneel would have simply been passed to any daughter or granddaughter she had in the future. The way things played out in the series turned out to be the better option, because it led to Naneel's final destruction.
In Mai Otome, Otomes are required to abstain from heterosexual romance, as semen will render their bodies unable to use the nanomachines. Arika in particular starts out as ignorant of how love works, but while she develops feelings for Sergay over time, in the end, she fully commits to being an Otome.
Keima from The World God Only Knows, despite being known all over the Internet for being "The Capturing God" for his incredible skills at Dating Sim games. He didn't even raise an eyebrow when he accidentally saw Haqua changing in front of him, and during his "Freaky Friday" Flip with a girl, he doesn't take advantage of the fact, preferring to play his games.
Barnaby from Tiger & Bunny. A natural when it comes to playing The Charmer, he has no problem with acting cool for the sake of the fangirls in order to stay true to his position as HeroTV's no.1 Mr. Fanservice; but in private he has displayed zero interest in romance. He's said to have had a huge fan club back when he was at school, and apparently ignored all of them. Despite working alongside a cute tomboy (Pao-Lin), an aloof bishoujo (Karina) and a hot career woman (Agnes), he has yet to spare any of them more than a passing glance. This might, of course, be due to the obsession with revenge which has caused him to reject personal relationships almost completely — though that's never stated outright by him or anyone else.
But the character questionnaire does have him revealing that he had a crush on a girl prior to the series. Thereby it's likely that he follows the "Love is a Distraction" school of thought. And now that he seems to have lightened up and gotten over the aforementioned obsession...
Ginko from Mushishi is very much this; though whether it's of his own volition or not is somewhat questionable. Due to possessing an unusual physiology that attracts mushi to him, he cannot stay in any one place or with a 'normal' person for a long period of time, and is thus forced to wander the country while acting as a mushi exorcist of sorts. His unusual looks and calm, always-in-command personality make him an instant Chick Magnet in-universe — but while he is kinder to most of the female characters than he is to the male ones, he has never displayed any active interest in romance. This might be indicative of supreme self-control or personal preference; despite having its fair share of romantic subplots involving the supporting cast, the story never brings up a serious prospective Love Interest for Ginko.
The Medicine Peddler from Mononoke is an enigmatic, mysterious Chick Magnet, and the only good-looking male character in the series. Many of the ladies he encounters develop a crush on him — specifically Kayo, with whom he gets quite a bit of Ship Tease (though it's more 'tease' and less 'ship'). But then again, the women are human while he almost definitely is not, so it might just be that.
The heroine of Kino No Tabi, is casually but determinedly celibate — at least in the anime. The novel series, which is ongoing, still has a chance of bringing up an Official Love Interest for her — though so far no signs can be seen to that effect.
Ranma: I'm in the middle of my training. I can't let some girl distract me.
Yanagin in Daily Lives of High School Boys hates the idea of dating in general, as she thinks guys are all losers. In fact, acts violently on the idea of any female dating a guy, or trying to make themselves attractive to a guy.
Kurosaki from Kurosagi is completely disinterested in starting a relationship or even showing any sort of affection to women. Even after Tsurara confesses to him, he brushes it off like it never happened.
Keisuke Takahashi in Initial D feels love is a distraction from honing on his racing skills (to beat Takumi, no less), though he does have somewhat of a love interest.
Dai'chi from Kotoura-san isn't a single bit interested in his Childhood Friend Yuriko's sexual teasing, and so she was actually jealous about Haruka having Manabe— the latter maybe too perverse, but he does have interest after all.
Yuriko: Manabe-kun has his issues, but being ignored really hurts a girl...
Minato Sahashi from Sekirei has some romantic moments with his Battle Harem, but remains a virgin due to a combination of chivalry, performance anxiety, and his ABSOLUTELY TERRIFYING land lady. Illicit relationships are strictly forbidden at Izumo Inn and it would be such a shame for him to end up homeless~
Batman, in many incarnations, adheres to a combination of most of the above: love as distraction (his work is his life); love as beneath him (he sees himself as something more); the danger magnet issue (amusingly subverted when, in an episode of Justice League Unlimited, he tried to use that as a reason he couldn't date Wonder Woman; she then demonstrates that he'd be in more danger than she); his Secret Identity, although potential love interests have occasionally discovered the secret anyway; and depending on the actual universe, bad relationships in the past (he maintains that one of his few actual lovers, Talia al Ghul, drugged and raped him).
With the Reboot it seems the whole Talia thing was consensual. He still wasn't proud of it though.
Catholic-Boy-Scout-type Tintin has it easy when it comes to resisting carnal sins. There are almost no women in the cast of his adventures, and the few that appear are hardly what anyone would consider "appealing". (Well, let's be honest here — Hergé Remi didn't draw noticeably attractive men with any great frequency, either.) He may count as a Chaste Hero too, since the whole issue of romance is never mentioned in relation to him.
Lucky Luke, being a lonesone cowboy who keeps moving and rarely stays anywhere more time than it's required to solve a case, has absolutely no interest for women or any relationships, though unlike Tintin, the subject is aborded; in "La Fiancé de Lucky Luke" especially, Luke mentions his opinion about both marriage and love, making it clear he is, not only uninterested, but almost revulsed (to the point he almost refuses a mission that consists in escorting a large group of women, fearing they might attempt advances on him... and they do). Notably, he has a female Platonic Life Partners with Calamity Jane.
Jughead Jones actively shuns romance, because he's simply more interested in food than love. He remains good friends with Betty, and he and Veronica can usually tolerate one another. Ironically, there has been more than one female who has persistently hounded him due to some infatuation with his aloof, nonchalant nature towards the fairer sex.
Empowered throws out a justified example: Ninjette uses a ninja technique that channels her sexual frustration into fighting prowess.
Judge Dredd. Sexual relationships (or "extra-judicial liasons") are illegal for street Judges.
The Marvel/Dynamite comics creation Red Sonja. (As opposed to Robert E. Howard's original Russian sword-maiden of the same name.) Gang-raped to the point of death, Sonja was gifted with revenge by the god Mitra (or the goddes Scáthach, Depending on the Writer). So long as she "knew no man," Sonja could best almost any man alive in combat. To become her lover - and presumably destroy her gift - a man had to beat her in a fight - a task even Conan the Barbarian found difficult, if not impossible, to do.
In Sin City, Wallace, a surprisingly stoic figure in the series, tries his best not to give into the various temptations the city has to offer. At one point, a femme fatale refers to him as a monk when he refuses to be seduced.
The Spirit: While a total Chick Magnet, The Spirit spent most of his time being embarrassed by and fending off women's advances, a not-uncommon trope seen in comics and movies of the 30's and 40's.
In Marvel Star Wars, most of the time Luke Skywalker is one of these. Pre-ROTJ comics have him interested in Leia and shy about going through with a Relationship Upgrade, but also unwilling to look at someone else because of her. Until very late in the series he actively runs away from Zeltrons, an entire species who think he's the most gorgeous man alive, and he puts up with the attentions of one who becomes an ally only reluctantly. He seems shy and massively taken aback when people express interest in him.
Averted in the novels where he marries Mara Jade.
Despite spending time as a child prostitute on the streets of New York City, X-23 is this throughout most of her history. She develops a mutual attraction with Hellion, but due to her incredibly traumatic childhood Laura struggles with personal relationships, which leads to her keeping him at a distance. Their one kiss was unwelcome on Laura's end, and she ultimately breaks things off with him for good by the end of her solo series and has not entered into another relationship in any of her books since.
Sunny Breeze of Racer And The Geek is this for a number of reasons, from having issues with being touched, to thinking himself unworthy.
Celestia declares both Luna and herself this in The God Empress Of Ponykind, saying that neither sister will take a mate or lover while ruling Equestria. This actually turns up in the sequel, The Warmistress of Equestria, when Luna meets Cadence and jumps to the conclusion that Celestia went back on her vow and Cadence is her daughter (she's not).
Subverted in the 1987 movie version of Dragnet. Although Joe Friday turns down Sylvia Wiss, who practically throws herself at him, and lectures his police partner about how it was the right thing to do, he does eventually end up with [The Virgin] Connie Swail.
What ultimately attracts Joe to her is that she's every bit as chaste and wholesome as he is.
A parody of this character type can be seen in the movie Monty Python and the Holy Grail with the hero "Galahad the Pure", who finds himself visiting a castle filled with nubile, eager young virgins whose charms he (unsuccessfully) tries to resist, but much to his dismay he is 'rescued' by Lancelot. Many of the King Arthur stories this movie is based on feature similar scenarios with chaste, chivalrous heroes having to face temptation from virginal and Vampish seductresses.
Zoot: "We are but eight score young blondes and brunettes, all between sixteen and nineteen- and- a- half, cut off in this castle with no one to protect us. Oooh. It is a lonely life: bathing, dressing, undressing, knitting exciting underwear."
Again spoofed in "Martyrdom of St. Victor" from Monty Python's Contractual Obligation Album: Victor is all too willing to succumb to the temptations of the maidens, but the Lord smites them anyway. Victor calls the Lord a rotten bastard.
In Impromptu about the romance between George Sands/Aurore Dudevant and Frederic Chopin, Chopin's tuberculosis makes him a little hesitant to take things to the next level with Aurore.
Frederic Chopin: Certain acts are... uh, unseemly. They are unsuitable.
George Sand: Chopin... it's an act of love! It's the divine mystery itself!
Frederic Chopin: You must think I'm inexperienced, but I assure you, I was baptized... in the brothels of Paris, when I first arrived. But, um... I'm so ill... and I have been for such a long time, and my body is such a great disappointment to me, that I've already said goodbye to it, I'm... not really * in it* any more, I'm just... happier floating about in music. And if I should come back... inside this miserable collection of bones, then I... am afraid that it would probably collapse altogether. Forgive me. I'm ashamed.
George Sand: No, no. Forgive me. I'm a fraud, you know. "Divine mystery"? I never experienced that with anyone!
Rustlers' Rhapsody is a parody of old B-Westerns, so at the start singing cowboy-hero Rex O'Herlihan never does anything more than chastely kiss the girls before riding on to the next town. After a false start or two, he finally "gets better".
Parodied in The Librarian where, after another relationship fails because of his job and his co-workers encourage him to think of himself as a "celibate monk", Flynn threatens to kill himself (with Excalibur).
His next fling is a (hot) 400-year vampire... who chooses to face the sun at the end. Surprisingly, Flynn feels better after this.
Inverted in Milos Forman's Amadeus, where we have a Celibate Antagonist in Salieri, whereas Mozart is portrayed as something of a Casanova.
The Director's Cut contains a part where, after Mrs Mozart comes to him for help, he demands that she return to him that night in exchange for his support. However, it's subverted even then; he lets her undress before ringing the bell for the servant to show her out. Whether he planned from the start to humiliate her out of spite, or whether he actually intended to go through with it but found himself unable is unclear; Salieri explicitly states that he was "in love, or at least in lust" with another girl Mozart bedded, so apparently he isn't asexual, but for whatever reason he did not actually blackmail sex from Mozart's wife.
The 1967 spoof Casino Royale has David Niven as the original James Bond, a celibate recluse (See Bad Romantic Experience Part 2) who views his namesake's behavior with disdain, and resists almost certain temptation in a scene that anticipates Monty Python's Castle Anthrax.
In The Golden Child, the Old Man assigns Chandler Jarrell (Eddie Murphy) a task of purification in order to fully realize his role as The Chosen One. This task involves remaining celibate, which is tough for Jarrell because he's got the hots for his Sidekick Kee Nang, and made even more complicated by the facts that (a) he's not allowed to tell her about it, and (b) once he stops being such a Jerk Ass, she starts falling for him.
The protagonist in The Wicker Man is a virgin due to his strong Christian faith. He's even able to resist the barkeep's daughter stripping naked and doing a magic wall-slapping seduction dance in the next room.
Ironically, that's one of the factors that made Lord Summerisle pick him as a prime candidate for sacrifice!
The eponymous Mystery Team, mainly because girls are icky. Jason eventually outgrows this.
Averted in Black Death. Even though Osmund is a monk, he secretly has a lover.
Unforgiven: Though his partners readily accept "advances" from their employers (the town brothel), William Munny considers himself still married to his deceased wife and stays faithful.
"So, what, you just use your hand?"
In Unforgiven's Spiritual Successor, The Twilight Samurai, Widower samurai Seibei rushes home to take care of his mother and daughters after work rather than join his coworkers for drinking and geisha entertainment. He also refuses his uncle and best friend's offers to arrange a second marriage, though in the latter case he's motivated more by shame of his poverty than genuine disinterest.
The Jedi order immediately before and during the prequel trilogy from Star Wars. The defying of the rule by Anakin and the forbidden love that ensues is a plot point. Technically, Jedi aren't allowed to form romantic attachments. One-night stands are okay but marriage is not.
Averted by Luke's New Jedi Order in the post-Return of the JediExpanded Universe and by the Jedi of the Old Republic era, where marriage between Jedi is allowed, and manage to successfully return back to prominence despite violating the previous order's teachings.
Genuine Arthurian example: Sir Gawain shares the bed of the Green Knight's lady night after night, but doesn't take advantage, as that would violate the laws of Chivalry and Hospitality. This display of virtue saves his life.
Probably from the same root story: Pwyll, from the First Branch of the Mabinogion, chastely shares a bed with Arawn's wife, despite being flawlessly disguised as Arawn himself, which results in a lasting friendship between the two men.
Ged, the protagonist for most of the Earthsea Trilogy, is celibate because he is a mage. This accounts for a complete lack of romance in the first three books, even when a pairing up, first with his friend's sister and then with Tenar, looked to be inevitable. All the mages in Earthsea are celibate by rule, in theory because they will lose their power unless they are chaste, though the truth of this belief is not exactly confirmed. It's implied in Tehanu (by a village witch, who may not be the most reliable source) that wizards use some sort of spell to render themselves asexual, or possibly just make it easier to be completely celibate. She doesn't go into details. Later on Ged mentions he just didn't think of it or feel any urge until he lost his powers.
Sherlock Holmes, the eponymous character from the original novel and short story collections, considers "Love is a Distraction" to be his watchwords — so much so that he's obviously both aromantic andasexual.
Irene Adler, who appeared in the short story A Scandal in Bohemia, actually managed to upstage Holmes; this earned her begrudging admiration from the famous detective, Ensemble Dark Horse status in the fandom, and Promotion To Love Interest in many adaptations — though in the original series she never makes an appearance in any other story and is only ever referenced by Holmes once or twice afterwards.
Enjolras, from Les Misérables also has "Love is a Distraction" taken to extremes, as evidenced by his introduction and by his reply, when one of the others is commenting on how the others all have mistresses, of Patria.
Biggles hardly ever had time for women, except that one time when he fell in love with German spy Marie Janis in the short story Affaire de Coeur. This is an interesting example considering pilots are usually portrayed as babe-magnets.
Raistlin Majere, antihero of the Dragonlance books. Actively manipulating the lovesick, annoying Crysania to his advantage, he resists the temptation to actually do anything with her because A) it's beneath a mage of his stature, B) he can't afford to be distracted from his "Overthrow the Gods for No Good Reason" project, and C) he had sex once before and was crap at it. And, though it's not explicitly stated, suspicions are that, were he to actually try anything as physically vigorous as sex with Crysania, he'd probably just wind up coughing blood all over her and collapsing into a heap, which, whatever way you look at it, isn't very romantic. There is possibly some inconsistency over whether Raistlin actually ever had sex or not. The Legends trilogy very strongly implies that he did, with one of Caramon's ex-girlfriends but The Soulforge, which covers the time period it would have happened equally strongly implies he remained a virgin (there is a girl, again a lover of Caramon and there appears to be budding mutual affection but... well read it yourselves).
You forgot to mention Crysania had THE hots for him. He could have done anything with her, without even having to resort to magic or anything. For such a brilliant wizard, he's actually quite stupid.
There was a short story called "Raistlin's Daughter", which implied he may have had a daughter, in the more or less conventional way and was magically made to forget the experience. Interestingly the entire story is treated as an in-universe rumour and when Raistlin encounters a girl claiming to be his daughter in Dragons of Summer Flame he drolly comments on his bad luck at sleeping with a beautiful woman and not remembering it. For the record the girl in question is not his daughter, much to the relief of his nephew Palin.
In Lamb, Joshua was told by an angel that he could never "know" a woman, but never explained exactly was meant by that. Josh and Biff take it in the Biblical sense, and so Joshua remains celibate his whole life (though Biff gets around enough for the both of them).
The Obsidian Trilogy, written by Mercedes Lackey and James Mallory, features a hero who remains chaste and celibate — virginal and unmarried, respectively — for a year and a day in return for his life being saved by a unicorn. The penalty for breaking his vow, since his life was saved, will of course be death by goring. While the first woman he meets is his sister, and the next woman he finds himself intrigued by is the queen of the elves and happily married, the third woman he is attracted to is neither attached nor unattractive nor uninterested in him...
This case also gets an interesting treatment in that the unicorn apparently becomes fertile (or non-celibate) because of the hero's year of celibacy. The hero and unicorn's parting at the end of the series states that the hero no longer needs to be celibate, but that the unicorn won't have to be either!
According to Harry Turtledove's Honeymouth short story, you can be a cussing, hard-drinking mercenary who rides a unicorn into battle and still be able to satisfy a full whorehouse each night, not to mention being satisfied yourself. Apparently the unicorn's radar can't distinguish between those who are still technically virgins and those who are truly chaste.
Doc Savage's unusual upbringing has made him ill-equipped to deal with women on any level other than "save from peril." He's smart enough to foist interaction with women on his companions for the most part, but seems profoundly uncomfortable when this is not possible.
Taken way, way to the extreme in the Leo Tolstoy novella The Kreutzer Sonata. Not only does the protagonist kill his wife in a jealous rage, but he makes the argument that one should renounce sex in any circumstance, including marriage, and that the subsequent death of the species would mark humanity's highest moral achievement. The fact that this story is more or less an Author Tract brings it perilously close to Squick. People are already working on this.
Harry Dresden from The Dresden Files spends a heck of a lot of the novels not getting any, and being quite bitter about it. Though he's given a few chances, he never takes them because they generally come with a lot of baggage (e.g. she's a lust demon, or his underage apprentice), and he refuses to enter into a relationship which isn't pure and based on love, and he also doesn't want to bring anyone else into his dangerous world if he can help it. The fact that his first girlfriend was brainwashed into trying to kill him, and whom he thought for years he had killed and his second girlfriend got turned into a vampire because of his involvement with her may have something to do with it. Although even with that track record, succubi making fun of how pathetic your sex life is has got to hurt. It gets to the point where it turns out Harry's latest love interest, Anastasia Luccio, was psychically mind-controlled into being attracted to him.
Having Carlos, who until that point certainly talked a good game, outed as a virgin by said succubus must have taken some of the sting out of it (or at least given him an ample means of redirecting the mockery). It also makes him another example, though his reason (for that matter, whether it's a conscious choice or just lack of opportunity) isn't explored.
Phury of the Black Dagger Brotherhood takes a "Love is a Distraction" vow of chastity when he comes of age and decides to search for his kidnapped twin.
Every wizard on Discworld is expected to remain celibate; the official reason is that sex drains magic power. The actual reason is that being the eighth son of an eighth son guarantees you will be a wizard, and if such a wizard then has eight sons, his eighth son will be a sourcerer. And you really do not want to meet a sourcerer.
Unseen Academicals does admit that celibacy for wizards is less stringent in Genua, where Bengo Macarona was involved in at least one divorce petition. He wasn't married, and it was the wife who filed the complaint against his philandering, so in this case there wasn't any risk of sourcery.
This seems to be getting glossed over in more recent books: apparently it was okay for Professor Earwig to marry, as long as he retired (see "The Sea And Little Fishes", A Hat Full of Sky and Unseen Academicals), and in Making Money, we're told the students in the Post-Mortem Communication Department view the black robes and skull ring as a "babe magnet". Currently, it seems that wizards are forbidden to marry for the much same reasons as Oxbridge dons were until the 19th century; they're supposed to be Married to the Job.
Rincewind, despite being a scruffy abject coward, is propositioned by ladies surprisingly more than one would expect. Or, he at least seems to spend a lot of time around them, including the scantily clad variety. However, as his mind is usually occupied with running away, nothing ever comes of it. Also, he's aware of his status as a Cosmic Plaything and Fate's Butt Monkey, so any time someone is nice to him, he assumes it's to set him up for a bigger fall.
Once, while abandoned on a desert island, he is approached by several amazon-types looking for a man to help them procreate and rebuild their civilization. Unfortunately for him, he was completely obsessed with potatoes at the time and thought that they were offering him some. It was only some time after he was whisked away by magic that he belatedly realized what they had been offering. Talk about missing the ball.
However, in The Light Fantastic the narration does mention that Rincewind had had some orgasms in his life, occasionally even with a partner.
Also from Discworld, Granny Weatherwax. After all, she tamed that unicorn... which really shocked her friend Nanny Ogg and the revelation made Ridcully, her one time love interest, get rather soppy. Note that Granny's celibacy has nothing to do with magic, as witches aren't subject to the same prohibitions as wizards. Granny comes under the "Love is a distraction" heading, though; it's a distraction from the pursuit of magic, so in a way her celibacy does have something to do with magic.
The ideal of both the Night's Watch and the Kingsguard is this. (Technically the vow only states "father no children" with regard to that, but the implications are clear and Martin himself has said that both are supposed to be celibate.) The practice, on the other hand...
Jon Snow gave a shot at this, refusing to go to the whorehouses when the other boys on the Wall did, refusing advances (all to obey the rules of the Night Watch). Didn't work out so well for him. Samwell Tarly was likewise forcibly thrown into his Love Interest's bed.
Knowing of the faultiness of such a pledge, the slave traders who own The Unsullied castrate the slaves for just this purpose. The slave trader proudly points out that while the Night's Watch and Kingsguard claim celibacy, The Unsullied are the only ones who are truly, well, unsullied.
Pretty much every single main character of H. P. Lovecraft's stories is too busy being chased by tentacled monsters and/or slowly losing his sanity to get involved in any kind of romantic and/or sexual relationship.
Joscelin Verreuil in the Kushiel's Legacy series is sworn to celibacy as part of his vows as a Cassiline monk. Played up for much angst in the second book, but he and Phedre are finally together for the third book.
In the Kate Daniels novels by Ilona Andrews, Kate remains celibate for much of her adult life. Partly because she thinks friends and lovers will distract her from her mission in life, partly because everyone close to her dies violently (her mother, her father, her mentor, and her friend), partly because sex would expose her secrets, partly because any guy powerful enough to protect himself from the skeletons in her closet probably didn't get that kind of power by being ethical, but mostly just because she's afraid of being hurt or rejected.
Drizzt in Bob Salvatore's Forgotten Realms novel series followed this trope for some time. He wasn't interested in casual sex. His first contact with sex was witnessing a graduation ritual for female priests, that involves the summoning of a 5-meter-tall demon. His first and so far only girlfriend was once involved with his presumed-dead best friend; and things got complicated when he was rescued from hell. Eventually, Drizzt allowed himself to love, and started getting some regularly. Then she died.
Solomon Kane is a devout Puritan and remains celibate because of his religious convictions.
Which is not accurate, since Puritans believed God wanted everyone to have (marital) sex.
Solomon Kane knew the "kisses" of a "deathless queen in a city old as Death," and compares her with Lilith (this refers to the attempted seduction by Nakari, a vampiric — or at least very bloodthirsty — queen of a lost African city). The same poem (Solomon Kane's Homecoming) implies that he had an old lover at home whom he was hoping to return to.
David Eddings's character Sir Bevier (from the Elenium and Tamuli novels) is aware that his good looks make him irresistible to women. Because he's the one most likely to abandon the steel for the cloth, he elects not to do anything about it.
Prince Rupert is very much a Celibate Hero in Simon R. Green's Blue Moon Rising, so much so that he even rides a Unicorn and is rather defensive about it. The reason for this is that as a second son he isn't allowed to be sexually active in case of Dynastic complications. This is a minor Truth In Literature, as many younger sons of nobility were packed off to the priesthood for much the same reason in the middle ages, and it had about the same level of effectiveness then as it does in the book.
John from Manly Wade Wellman's 'Silver John' stories, until he meets and weds his true love Evadare. Given John's strong Christian coloring, this is probably a rare modern example of a hero celibate by belief system.
Sergeant Jean in Seven Men of Gascony doesn't seem to have any interest in such things although it is not said why. One character speculates that he is Asexual though it is more fun to think that he had a lover in the past and never got over her.
Emilio Sandoz in The Sparrow. All the Jesuits on the Rakhat mission are.
Lord Meren, from Lynda Robinson's ancient Egyptian mysteries, has avoided serious romantic relationships since his wife passed away, having been so deeply in love with her that other women don't measure up. He has casual sex on occasion because it's normal social practice for noblemen, but the only woman he's emotionally attracted to is loaded down with political baggage that would compromise his objectivity as the Eyes of Pharaoh.
Word of God has it that after his crush on Gellert Grindelwald caused Dumbledore to lose his moral compass and buy into Grindelwald's beliefs about the subjugation of Muggles, which led indirectly to the death of his sister, he deliberately gave up on romance and focused upon his studies for the rest his life.
There's also Snape, though more of an anti-hero, who apparently never has sex due to his unrequited love for Lily.
Subverted with Mudfur. He's already a father while he was a medicine cat, but he already had kits with Brightsky when he was a warrior. But after her death and the deaths of three of their kits, THEN he became a medicine cat.
In Jack Campbell's The Lost Fleet, there is exactly one woman in the fleet that it would not be improper for Geary to have a relationship with. Then she learns her husband might be alive. There is plenty of UST between him and a subordinate, but they aren't even allowed by regulations to talk about it.
Orual, the narrator and main character of Till We Have Faces, rather obliquely mentions near the end of the novel that she never lost her virginity. This is partly because as queen regnant she would have to give up her power to her husband if she ever married, partly because she has a rather negative view of romantic love thanks to one sister's shallowness and the other's being Married To A God, and partly because she's convinced that she's so ugly no man would ever be attracted to her, queen or not.
In Mercedes Lackey's Firebird, Ilya unwillingly becomes this. Once he takes on the role of the fool, the women of the palace lose interest in him.
In 1356, we have the Sire Roland de Verrec, who as a boy had a vision of the Virgin Mary, and is determined to remain chaste until he marries. Other men mock him for his virginity, though not to his face — he is an undefeated tournament champion and utterly lethal in battle.
In Mercedes Lackey's Four and Twenty Blackbirds, Bishop Ardis is celibate by virtue of her religious vows. She is strongly attracted to the book's other protagonist, investigator Tal Rufen, and briefly contemplates the idea of giving up her vows. Eventually she decides that she may be attracted but she is not in love, and that she is content with her life as it is.
Also from Lackey Tarma in the Vows and Honor books is a Swordsworn, sworn to serve her people's Goddess as a warrior. In this case, rather than force her servants to torture themselves, the Goddess simply removes their ability to feel sexual desire entirely. This is particularly good for Tarma, who became Swordsworn in the aftermath of being gang raped by the people who killed her clan.
An antiheroic example can be found in Riesel Tales: Two Hunters. Ramy Dusotes, one of the two eponymous hunters, actively avoids romance due to the disturbingly high number of perverts and sexual predators on Riesel (which includes her business partner Runge Margavo). Discounting her tomboyishness, she deliberately avoids wearing makeup or feminine clothes and retains a fairly pudgy figure in order to strengthen her barrier against Riesel's shallow lechers.
Live Action TV
Marcus Cole, Ranger extraordinaire, from Babylon 5 tries to save himself for the right woman, only she never gets around to 'boffing' him before his Heroic Sacrifice.
FBI agent Paul Ballard in Dollhouse, shortly after he found out his girlfriend's a doll. He even refused to sleep with Echo, whom he's crazy in love with, for a long time, because she was messed up from being a doll and he felt it would be wrong.
Supernatural: Unlike his brother Dean, Sam really, really tries to do this since everyone he has sex with winds up dead. But, fortunately for every fangirl out there, that doesn't stop him from having rough, hot, sweaty and completely gratuitous werewolf!sex in Heart.
The girl of the week in "Monster Movie" asked Dean if he was this. He did not reply "HA HA HA!"
Secret Agent AKA Danger Man: John Drake was meant to be seen in contrast to the oversexed Bond and Bond clones, per request of the show's star Patrick McGoohan, who found Bond morally reprehensible because of his promiscuity. It was not that John Drake might not have a sex life when outside of his job, but when he was working his attitude towards women was strictly professional.
Angel, while definitely not one of those for most of his existence, became one after being cursed with a soul, initially because he was a complete loner. Later it turned out that a "moment of pure happiness" would break the curse, unleashing Angelus, so he had a good reason to avoid sex. Subverted in the second season, when it turns out that this doesn't just mean sex, he actually does have to be happy as well, and abandoned in the fifth when he realized this doesn't mean he can't have what a colleague describes as "acceptable happiness".
Oz qualifies as well in two instances. The first is when he declines Willow's advances, thinking it would get to Xander, maybe this was even her intent. Joss Whedon was the Writer on Board in this scene, saying 'Here's Oz, he likes Willow, she really likes him, but he isn't going to be a douche about it.' And again, after Willow cheats on him, she pulls out every stop there is (and some that hadn't been dreamt up) to seduce him. Oz declines, saying she doesn't need to let him into her pants to show how special he is to her.
In Carnivàle, it's strongly implied that Ben is a virgin, and he actively shuns sexual advances. This is related to the fact that he grew up with strict religious values pounded into him by an uncaring mother. When he does have sex with Ruthie he tells her that it was "a sin" and that it won't happen again. He also tends to freak out when others try to touch him. He does seem to change his mind later in the series regarding Sophie. It doesn't work out too well, though.
Daniel Jackson in Stargate SG-1. At first it's because his wife is being held prisoner, but then, even years after his wife has died, he still remains remarkably celibate. Although, nobody in this show tends to get a whole lot of action, except maybe Teal'c.
However, there are some exceptions. When devolved by a virus, Daniel shacked up with a woman from another planet. When made evil by a sarcophagus, he had a fling with the princess of that planet (Jack even lampshades him ending up with a girl on every planet). He also hooked up with Vala when they were stuck in a time bubble in the final episode (that was undone). Jack himself has had relationships (or at least a quick fling) at least three times, and Sam at least one.
All subverted. Jack didn't actually have any say in the first of his three 'flings', and it caused him to get the granddaddy of all STD's. The second one was when he'd already been stranded on her planet for three months and thought he was never going to get home. The third was the only one that qualified as a relationship, and it was peripheral and with a nice, normal CIA agent. Before the show he was married for at least ten years. The guys Sam have been involved with tally up as follows: Jonas Hanson, Martouf, Narim, Joe Faxon, Pete Shanahan. And all but Shanahan and possibly Faxon are dead, though one of them (Hanson) deserved it. One of Daniel's 'relationships' also fell under that first category, but firstly, his wife was an alien who was given to him as a gift. There was the previously alluded-to Hathor, then the woman with the Sarcophagus, then his ex-girlfriend who was taken as a host by the Goa'uld Osiris, then there was the very, very charged relationship between him and Vala in later seasons. Teal'c's current tally is up to four. It's possible that adultery is not a particularly big deal in Jaffa culture, otherwise we've just stumbled upon a less than honorable personality trait.
Actually, based on Teal'c reaction when he found out his wife had re-married, we can surmise that adultery is a big deal for Jaffa. In fact, there's even a term for what Teal'c wanted to do, roughly translated as "revenge of the wearer of horns" (in certain cultures, the "wearer of horns" is the term for a cuckold).
In fairness, other captains on Star Trek tended to not have much truck when they try something with a subordinate.
Indeed, Archer's only real relationship in the four years Enterprise was on the air was with another Starfleet Captain, Kirk's reputation for womanising is largely undeserved, Picard only had relationships with women he could barely tolerate (Vash and Lwaxana). Sisko was largely damaged goods until his son of all people set him up on a date, whom he ended up marrying.
There's one notable subversion, although it's not directly addressed. In the future parts of the series finale, it's revealed that Captain Picard married (and then divorced) Beverly Crusher.
The only time Janeway is shown to have a normal romantic relationship is when she was brainwashed (the crew was captured, brainwashed, and made to work in a factory).
Sheldon from The Big Bang Theory. He seems to be asexual, but also sees love as a distraction from scientific work.
Mal, who pretty bluntly admits in "Our Mrs. Reynolds" that he hasn't gotten laid in a long, long time. Though he does eventually manage to get somewhere with Nandi in "Heart of Gold."
Michael Westen on Burn Notice has rebuffed Fiona multiple times, citing his personal history, their problematic past history, her enjoyment of violence, the danger to everyone around him (which of course doesn't stop him from calling them to help with cases), the distraction, his higher purpose of finding out who burned him, and his patriotism.
Patrick Jane on The Mentalist has apparently made a Heroic Vow to avenge his wife before indulging in pleasures of the flesh. He turned down two attractive ladies at a bar who made a pass at him, flashing his wedding ring and telling them he was married. Jane sometimes flirts with women, but it usually ends with the outing of a suspect.
Cmdr. Ed Straker of UFO is manifestly celibate after an acrimonious divorce, after the loss of his son to his successor, and the death of his son, even thought a variety of attractive and eligible women have a go at him (e.g. Lt. Barry). His reaction to the rampant libido shown by the rest of his staff ranges from cold disregard to amusement.
Artie on Warehouse 13 has been this in his long years as a Warehouse agent until he started dating Dr. Vanessa Calder. However, since his current circumstances put him in more danger than usual, he's broken up with her and returned to this.
In the BBC TV series Sherlock, Sherlock Holmes expressly states in the very first episode that he considers himself married to his work, and that girlfriends and boyfriends are "not really his area." Creator Steven Moffat maintains, however, that Sherlock is not asexual - he is heterosexual but "monk-like in his devotion to celibacy" - and that this devotion may not hold out in the future.
Morrissey was very publicly celibate during the 1980s
Emilie Autumn has shunned romantic and sexual relationships after the situations which caused her to write the Woman Scorned part of her Opheliac album (Bad situations in the past). Just her crumpets and her plague rats/muffins now....also falls into "Love is A distraction" excuse. She makes all her music on her own and sets up her own tours. Does not have the time, does not want the time.
The title character of Richard Wagner's Parsifal, based on the old legend.
Well, yes and no. In his own opera, he is, but in the later-set though earlier-written Lohengrin, the title character is Parsifal's son.
Averted to various degrees in later adaptations of The Green Hornet; in the TV series Britt Reid was cast more as a rich playboy/publisher, and given the occasional Love Interest while Kato remained a celibate sidekick. This was probably an artifact of the series format; as a half hour series it would be difficult to shoehorn a romantic subplot into a show which could barely fit the action/adventure main plot within its runtime. Totally averted in the NOW Comics adaptation of The Green Hornet, which pretty well paired off almost all of the various Green Hornets and Katos with more-or-less permanent Love Interests.
Religion and Mythology
Roman Catholic Priests, in imitation (well, at least majority who are faithful, and who were not originally Anglicans that converted after becoming priests and being married).
Nuns as well. Mother Teresa counts as a hero.
Eastern Catholic Priests (the one in communion with Rome) are a double subversion—they can be married men, as long as marriage is done prior to ordination. In both Eastern and Western (read: Roman) Rites, once you are ordained, you can no longer marry.
Same rules apply to Eastern Orthodox Priests, as well as deacons in all rites. A man under Holy Orders is not permitted to take a wife unless given express permission to do so (which in the case of deacons is usually only given if his first wife dies and leaves him to raise minor children as a single father, and in the case of priests is extremely rare; it is unheard of in the case of bishops).
For the matter of that, even laymen who can't marry are expected to be this. And they don't even get to wear cool robes to make up for it.
Theseus' son Hippolytus was one of these, and it got him killed. There are risks to swearing off love forever when the goddess of love is very real and very petty. It's also a bad idea to mock said goddess in the process.
GURPS gives us the Chastity disadvantage, giving your Celibate Hero functional rules for what that entails.
Humorous footnote: The Eunuch disadvantage was also available (to males) in earlier editions, but its value was dropped from 5 points to a 1-point 'quirk' because too many Min-Maxing players were taking it.
Paranoiadoesn't have heroes, but does have universal celibacy due to hormone suppressants in the food supply. Some citizens do get off the suppressants, mostly either (a) High Programmers or (b) Troubleshooters stuck Outdoors during a mission and forced to eat natural food long enough for them to wear off. Some of these citizens end up going back on them voluntarily so they can concentrate on not getting killed. It's that kind of game.
One Feat offering in the Dungeons & Dragons suppliment Book of Exalted Deeds is Vow of Chastity, which gives a Player Character benefits, so long as he or she remains chaste. This Feat is a prequisite for two Prestige Classes (one of which is female-only and involves gaining a unicorn as your companion, naturally).
Japanese fighting games are riddled with this archetype, exemplified by Ryu ("The Fight Is All") of Street Fighter. SNK follows with Terry Bogard who's implied to be attracted to Blue Mary but keeps his distance, despite Mary's implied attempts to get closer (though she herself seems unsure because of her work). Inverted by Kim Kaphwan, who's married with two sons, and there are a number of others. Although Andy Bogard tries to project this in an effort to train and surpass his stronger brother, much to Mai's dismay.
Could be a case of Character Development or as the anime section above showed, Alternate Character Interpretation on SNK's part as the fighters are never shown to be at their peak when in a relationship or even thinking about it and all characters lost their Ryu-level invincibility once they have officially confirmed to be in a relationship with the exception of Andy Bogard who never surpassed Terry despite shunning Mai away. Robert Garcia could be a possible aversion as he teamed up with Ryo in the AoF games. Terry lost to Rock Howard and Kyo Kusanagi by the time he and Mary fought/talked together regarding their little attraction to each other indefinitely. Ryo never got back to his AoF days in KOF after he and King were recognized as a couple. Incidentally happened to Ken Masters too who was champion of SFII.
Art of Fighting and Fatal Fury are one continuity; The King of Fighters is another. They share the same basic backstory, but that is where similarities in terms of plot elements end.
Played with in Samurai Shodown, though. Haohmaru has a girlfriend, yes, his priority is fighting and Oshizu knows that very well; Nakoruru has Galford as her Dogged Nice Guy, but her own priority is being a Nature Hero; Charlotte also adheres to the trope after she finds out her affections for Haohmaru won't be returned... OTOH, Hattori Hanzou is married to a fellow Ninja named Kaede (and later was widowed) and Sieger got to tie the knot with his lady in liege, Princess Elizabeth.
Adell from Disgaea 2 spends most of the game loudly proclaiming that he can't stand women. This turns out to be due to a traumatic run-in with a succubus years before.
Laharl from Disgaea: Hour of Darkness is already 1313 years old, but can't stand sexy women, and doesn't appear to be attracted to non-sexy women either. This might also have something to do with the fact that he is Allergic to Love. He is a perfect example of the "Love is Beneath Me" type. Of course, we should point out that, centuries-old or no, Laharl has yet to complete puberty and is still considered Just a Kid by demon standards - he acts confused/horrified when an older character tries to give him The Talk.
In the novels, he's an Unwanted Harem, attracting both young girls (such as Etna, Flonne, her younger sister Ozonne, Gordon's 13-year-old daughter Jane,) and Sakura, an adult woman.
Ike from Fire Emblem: Path of Radiance and Radiant Dawn shows no romantic or sexual interest in women even up to the end of the games he stars in. Unlike every other Lord in the series, he doesn't even have the option to marry! However, there is a great deal of Ho Yay between Ike and Soren (and Ranulf to a lesser extent). Arguments over Ike falling into this trope or Hide Your Lesbians being in play still persist.
Fire Emblem Awakening reveals that he has a descendant named Paris, but with the possibility that he's actually an indirect descendant (Ike's sister gets married at the end of Radiant Dawn) and nothing referring to Ike having a wife or children, he still possibly qualifies as this trope.
Flik from Suikoden has refused a lot of suitors who flirt with him, especially Nina, because he has made a vow to be loyal to his first lover Odessa... even though she's already dead.
Worth noting that it might be cultural and not just personal. Men from the Warriors' Village inscribe the name of their true love upon their sword—Flik's love for Odessa was strong enough that he named his sword after her. To Flik, there simply may not be anyone else he's capable of loving on the same level he loved Odessa.
Ivy from the Soul series, amazingly, is strictly celibate despite being Ms. Fanservice incarnate. This is due to her cursed lineage, which she doesn't want to risk passing on to a child.
It should be noted that this is a bit of a departure from III, where Kilik either flat-out asks Xianghua to be with him (his ending) or is oblivious to her hints (her ending). Then again, in their endings, they had finally destroyed Soul Edge, which was a non-canon scenario.
Additionally, Xianghua's daughter Leixia is confirmed to be a playable character in V (which is set seventeen years after the fourth game). It turns out that Kilik is not the father, much to the surprise/dismay/anger of many. Xianghua was instead married off to Ming general Yan Wujin. However, Kilik—before leaving Xianghua—spent one last night with his lover. And that's how Xiba was born.
As much as the Shippers want to deny it, Link from The Legend of Zelda typically just rescues the princess and leaves it at that. Of course, in a series with humungous amounts of Ship Tease, one can't help but think it's because the developers couldn't decide on which girl to pair him up with.
Especially blatant in The Legend of Zelda: Ocarina of Time: Despite being 12 years old, Link is Chick Magnet incarnate. Let's count them: Kokiri Sage Saria, Farmer Girl Malon, Zora Princess Ruto, Probably Princess Zelda and even Gerudo sage Nabooru makes a comment in that direction! Still, he manages to avoid all of them, even the one who tried to get him engaged with her. The Legend of Zelda: The Wind Waker mostly tried to avoid giving Link such an Unwanted Harem, with Medli instead being slightly attracted to Prince Komali, the two girls on Windfall island either having different problems or already being in love, and Aryll being, well, his sister. Only the creepy fairy-queen is seen flirting with him and she's never seen again after that.
This is technically subverted if you count The Legend of Zelda: Twilight Princess. The character of the Hero's Shade is heavily implied to have been a previous Link, most likely the one from Ocarnia of Time, and even tells the titular Link of that game that the techniques he is teaching him are not to leave their bloodline confirming that they are of the same family line. So it seems that at least one Link got busy at one point.
Subverted in Skyward Sword. At the opening of the game, it is clear Link and Zelda are at least extremely close childhood friends, but no romantic interactions go through between them. There is almost one before a tornado sent by Ghirahim drags Zelda to the surface and Link goes on a quest to save her. By the end of the game, however, Zelda and Link decide to stay on the surface, and the Royal Family in future games has to be built somehow...
Zero, after his tragic first girlfriend, Iris, who he killed, accidentally, by his own hands, likes to keep things merely professional with future female co-workers from now on, as seen with X8's Layer (although he's also oblivious to her feelings).
It's possible to play Shepard this way in all Mass Effect games, usually of the "love is a distraction" variety.
Samara is a Double Subversion. While her Code does not restrict romance, she merely chooses not to engage in it. It turns out this is because her three daughters all suffer a rare asari condition that basically makes them sexual vampires, and have to live in isolation - except for the one who went on the run and became a serial killer.
The Master Chief in Halo, like all SPARTAN-II members, underwent extensive surgeries and procedures to maximize performance. One side effect of his condition is a decrease in...er...interest. Though this side effect is described as a common and likely result of their hormonal adjustment, it is not universal or absolute when it does occur, leading to a few exceptions:
Two members of Black Team were into each other, going so far as to make out in the showers (they were clothed, but it was pretty intense and it's possible they might have gone farther). As luck would have it, another member of their team happened to be an exception as well, apparent from his ratting them out in jealousy.
Another Spartan, Maria, appears to have become married and taken on a family after being too badly injured to maintain active service. According to supplemental materials, Kat and Carter of Halo: Reach's Noble Team were previously in a relationship, which is hinted at in the game itself.
Kat and Carter were SPARTAN-IIIs, which involved different modifications, especially since the process was perfected in the meantime (none of the SPARTAN-IIIs rejected their changes unlike their predecessors).
Prince Sebastian Vael of Dragon Age II actively avoids sex, due to his vows of chastity upon becoming a brother of the Chantry. Players can enter a romance him, but don't expect him to sex with you.
Disturbingly, this is in part due to the manipulations of his parents. Sebastian's parents see him as superfluous, and did not want him siring children to challenge his brothers' claims to the throne.
Considering he's the last member of his family after they were betrayed and killed, he may have to break his vow in order to sire an heir.
The Reverend Theo of Schlock Mercenary is a literal version, since he took a vow of chastity. He eventually gets married, averted the trope but keeping true to his vow.
Captain Tagon has been shown to be firmly in the "bad relationship experience in the past". That is to say, the last girlfriend he brought home turned out to be an assassin, rigged with flesh-eating nanobots. The nanobots' first victim was his mother...and then it got worse, until his father had to step in and Kill It with Fire.
Jyu Viole Grace from Tower of God, who obviously knows what sex is, yet has no intention of having it. This tends to piss a few women off.
Howlett, The Hero in Daily Grind, is madly in love with Jolene, the Big Gal in the comic's Five-Man Band, and she's madly in love with him. But they seem unlikely to ever consummate their relationship since: a) he's a snake and she's a squirrel and neither's quite sure how to make that work physically; b) he was her legal guardian till she turned 18, and even though he's only 5 years older than her, the suggestion of Wife Husbandry gives him the Squick; and c) Jo is violently asexual due to her various blood chemistry imbalances and her Abusive Parents.
Lancelot du Lac in the early years of Arthur, King of Time and Space (in the Contemporary Arc he was studying to be a minister). Then the plot happened.
Homestuck: The main character, John Egbert, has decided to remain one as long as the SBURB session continues. (Perhaps not so surprising since the last time we saw him he was all of 14.) After he and Jade talk over their respective potential romantic interests (several of them each), John basically throws his hands up in the air.
JOHN: anyway, my point is, who even cares about all that?
JOHN: romance and dating are dumb and boring. we are legendary heroes, and we have bigger fish to fry. like that smug fatass over there on the horizon.
Kankri has also decided to abstain from sex or romance to better focus on his social justice goals...though he seems to have a crush on Latula. He doesn't seem aware, but everyone else sure is.
Daichi in Greek Ninja, who is not only annoyed by girls' attention, but also appears unaware of their gaze.
In Season 4 of Noob, Omega Zell reveal that he's deliberately avoiding any friendship or love relationship whith women until he becomes the game's top player. However, sinc he's not that foundof them in the first place nor hiding it, he's not exactly spending his time turning down an Unwanted Harem.
Mohandas Gandhi renounced all sexual activity at the age of 36, while still married. In spite of this, he would frequently sleep naked with very young women and girls, many of his own relation, to "test" himself. Some small controversy has arisen over Gandhi's complicated sexuality now that these stories have surfaced.
Sir Isaac Newton died a virgin. He said that one of the greatest things he could boast about is that he never had sex.
Philosopher Immanuel Kant also died a virgin, but he was asexual, so...
While he was still technically celibate, he was also in love with a pigeon and was pretty heart broken when it died.
Tesla: Yes, I loved that pigeon, I loved her as a man loves a woman, and she loved me.
Authority figures aren't above exploiting this trope for propaganda purposes, even if they don't really live up to it. Hitler kept his long affair with Eva Braun out of the public eye, in part, because his propagandists played off the "Love is a Distraction" and "Love is Beneath Me" themes, making it seem that Germany was all that mattered to him.
The same is true of Ho Chi Minh, who married a Chinese woman named Tăng Tuyết Minh before becoming president of North Vietnam. The couple were separated by his arrest in 1931 and it was almost twenty years later before she found out what had happened to him; however, the government never answered her requests to meet her estranged husband, and even today her existence is not legally acknowledged.
In defiance of this trope's Always Male status, how about Nancy"The White Mouse"Wake? A journalist hailing from New Zealand, she aided the French Resistance, and after her cover was blown, trained with the British SOE, returned to France, and went on to do such Badass things as riding a bicycle for 71 km to get much needed supplies and commanding 7,000 Maquis troops against 22,000 Nazi soldiers. She's the most decorated servicewoman of WWII and would like to be remembered as "the woman who turned down 7,000 horny Frenchmen."
Joan of Arc: national heroine of France, and she is well known for her virginity.
Although some historians suspect Lawrence of Arabia of having homosexual relations, most evidence points to him having a deep-seated fear of sexuality. In fact, his own brother once claimed to be positive that Lawrence died a virgin.
Andy Warhol's family insists that he died a virgin, and despite his often-erotic art, there is good evidence in his biography to believe this. He was also a devout Byzantine Catholic, which may have played a part in his decision.
General Charles Gordon (of Khartoum). Similar to Lawrence, many historians (notably Lytton Strachey) depict him as a closet homosexual or even a pederast. He certainly spent a lot of time caring for orphaned boys through his charity work. But in all likelihood Gordon was chaste, if not actually asexual, largely due to his evangelical Christianity. He once wrote a friend that he wished he was a eunuch!
Leonardo da Vinci is speculated by some scholars (including Freud) to have been homosexual, but celibate. He himself wrote: "The act of procreation and anything that has any relation to it is so disgusting that human beings would soon die out if there were no pretty faces and sensuous dispositions." - which doesn't necessarily mean he wasn't engaging in it.