Proving that all you need for a Heroic BSOD is paper, ink and whole lot of trauma.
Greystone Valley begins in the midst of the protagonist's BSOD thanks to the death of her father.
Alastair Reynolds - Revelation Space's Captain John Brannigan sufferes a Heroic BSOD after he discovers what he has become by the end of the book. A 4 km long starship. He tries to cut himself in half with a Deathray in Redemption Ark.
Sam and Lana from the Gone series, at the end of Lies.
Dekka, after Penny's visions made her think she had the bugs in her again.
Dekka again after Brianna dies.
Edilio too after he thinks Roger dies.
Dash Rendar from the novel Shadows of the Empire, which takes place after Empire. The bounty hunter was suppose to have fended off a missile attack from the Suprosa, the ship carrying the plans of the new Death Star, when it wiped out the Alliance's Bothan ships. Dash doesn't take kindly to the aftermath and continuously blames himself at the end of the battle. Towards the end of the novel, the Rebels inform Luke that the Suprosa had been using diamond-boron-armored weapons that are impenitrible to laser fire. He learns this only after Dash's supposed death...
Inkdeath: Author Fenoglio spends almost the entire book being depressed and cynical because he no longer controls what happens in the world he created, and it's going to the H-word.
The Star Trek: Voyager novel Mosaic details when Captain Janeway goes through one of these. Considering that Kathryn lost her father and her fiancee on the same day, she's entitled.
Captain Picard suffered something like this in Star Trek: Destiny when he came to the conclusion that the Federation could not win the war against the Borg.
In Anne Rice's vampire novels, Lestat spends several books in a catatonic state after an encounter with a being he believes to be Satan. It's not so much the encounter but the inability to accept that everything he has done after hearing Memnoch's story is a big Evil Plan and that all he has done is promote the Devil's agenda.
Lymond has these throughout Dorothy Dunnett's Lymond Chronicles. The most blatant is when he freezes after the chess game in "Pawn in Frankincense" when he is forced to sacrifice someone he cares for and has to be led back to his room, where he promptly faints. He subsequently experiences blinding migraines whenever he is reminded of that trauma or when he feels that the life of someone he cares about is at risk because of him.
Nicholas Fox, Lilian Bunting's nephew, flees the meeting near the end of Aunt Dimity: Detective and stands in a downpour without a coat. Lori cannot rouse him from his catatonia, but does manage to get him inside the vicarage and wrapped in a blanket before a fire. At length, he explains to Lori that he couldn't stand the villagers' callous attitudes toward Prunella Hooper's death from an accidental blow to the head. He worked as an undercover cop and saw his partner brutally beaten to death several months previously.
Harry Potter, where Harry locks himself in his room and refuses to talk to anyone after hearing that he is being possessed by the Big Bad. However, he is promptly told by another main character that he is being silly and nothing of the sort is happening, and everybody was jumping to conclusions anyway.
After witnessing his father and godfather bullying Snape via a Pensieve memory, Harry's horrified at what he saw and empathizes with Snape. His idealized view of his father has been shaken, but he later accepts that his father matured to become a brave and compassionate guy.
After Dumbledore dies and Snape escapes in Half-Blood Prince, Harry has a BSOD. Justified, considering what that means not only to him but for the future of the wizarding world.
"The Forest Again." He's in total shock, which is understandable considering that it turns out Snape was a hero, and Harry had to die at Voldemort's mercy in order to defeat him.
In Deathly Hallows'', Ron shuts down for several minutes when Hermione is tortured.
Drizzt, in some of R.A. Salvatore's later books (specifically The Hunter's Blades Trilogy), especially The Lone Drow, where he flips back and forth between this, murderousrage, and pure Wangst for most of the book.
Jake has one that lasts a whole year in the final Animorphs book, as a result of the final battle, in which he ordered his cousin to kill his brother - which she did at the cost of her own life, gaining nothing - and gave the order to massacre seventeen thousand defenseless Yeerks. To his credit, though, he waited until after the battle was over to have his breakdown.
Bella spends nearly the entire book of New Moon in this state after Edward breaks up with her. According to Word of God, Edward also spent most of this time curled up in a fetal position hating the world, before his suicide attempt.
In Twilight's fourth book, Breaking Dawn, Edward freezes up and apparently goes into shock after hearing Bella is pregnant with Edward's baby; something that wasn't thought possible. Edward also knows the myths of things like this, and in the myths, the mother never survives. Vampires in Twilight are normally very in control of themselves (socially; bloodlust is another thing), and Edward's mind basically shuts down. He lets his phone ring for quite a while, and his expression doesn't change at all after hearing about Bella's situation. While this might not sound like much, it basically means that Edward's mind asploded.
Ender's reaction to finding out the "wargames" had all been real at the end of ''Ender’s Game'...though this is somewhere between this and Angst Coma
Or his response after the fight with Bonzo. He held it together long enough to organise his army into formation, but then it's shown in Ender's Shadow that he has himself frozen and hands the whole army over to Bean. His attitude, or lack thereof, in his room after the battle might not be a BSOD on some characters, but for never-give-up Ender it's pretty serious.
Don't forget about the description of his trial for killing Stilson as well as Bonzo.
In The Hunger Games series, multiple characters hit the BSOD of PTSD. Katniss wanders out of coherence several times, most notably after watching Prim die in a ball of fire. She also has a brief but vividly described one in the first book, right after Prim's name is drawn at the reaping.
She has a pretty big one at the end of "Catching Fire" as well. In her narration she says she loses the will to live after President Snow captures Peeta and she realizes she'll probably never see him again.
A common theme the novels of H.P. Lovecraft is for the main character to witness something so horrifying that they pass out or go insane.
It happens again in Solo Command. This time, it's accidentally revealed that the one responsible for destroying Talon Squadron is currently a member of the Wraiths. After this revelation, Donos suddenly goes berserk, and attempts to shoot down his squadmate (who had executed a Heel-Face Turn in the previous book), nearly killing another squadmate in the process. He snaps out of it quickly, but this event reveals lingering issues that he still has to deal with.
Han goes through a pretty major one following Chewbacca's death.
This happens to Miles Vorkosigan from time to time — a particularly graphic example is in Memory. With all he's been through, it's a wonder he ever comes out of it.
At the end of the third Sir Apropos of Nothing novel, the eponymous (anti)hero gets an (anti)Heroic BSOD when he learns that Verah Wang Ho, the leader of an Asian-like crime syndicate and his temporary lover, is the Emperor's...brother. The BSOD consists of Apropos saying "I don't care" over and over, which just happens to be the trigger word of his Infinity+1 Sword, and the repeated triggering of the sheathed sword eventually causes a Hiroshima-like explosion (which is lampshaded in the last chapter, when he gives the sword to a fat man and his little boy).
Both Garion and C'Nedra have BSODs: Garion's comes after he burns Asharak to death outside the Forest of the Dryads and is relatively minor as BSODs go. C'Nedra has at least one brief one in the Belgariad when she realizes the fate in store for the soldiers she has recruited as the Rivan Queen; it could be argued that she spends virtually the whole Mallorean in one, with brief remissions. And then there was Garion's reaction in the Malloreon to the birth of his son. His entire brain shut down. Of course, Garion's brain isn't the most powerful organ in his body. This leads to quite a funny moment:
Garion: Bed....Baby....Wood..Fire, C'Nedra needs big fire..baby...
Polgara: Oh dear, it's going to be one of those.
The two companion books that serve as autobiographies of Belgarath and Polgara have an intersting case - after the destruction of Vo Wacune, Belgarath thinks Polgara has gone into this, but when you reach that point from Polgara's point of view it turns out she was faking it to get him to leave her alone while she orchestrated her revenge on the armies that destroyed it.
Polgara has a more serious BSOD when her sister dies. Belgarath snaps her out of it by giving her lots of orders to keep her mind occupied... and then promptly goes off somewhere private to have one for himself.
Silk gets one after visiting his mother. It Makes Sense in Context. He deals with it by drinking copiously, and is more or less back to normal (if cripplingly hungover) the next day.
In Artemis Fowl: The Lost Colony, Artemis suffers a very, very brief one of these when Holly is killed. To all appearences, he's completely unmoved, continuing to concentrate on the bomb, ignoring everything else as the same guy who killed Holly goes on to quickly murder everyone but Artemis; however, it's all he can do to keep his concentration, which turns out to be what saves them all. Just before Artemis gets killed himself, he looses a single shot from Holly's Neutrino in a seemingly random direction. Turns out that Artemis had the Timey-Wimey Ball all figured out, and the shot got pulled back in time to just the right second to stop Holly and everyone else from being killed in the first place.
Artemis: "You didn't kill my friends. That never happened."
In the novel Men at Arms this is Detritus's reaction to Cuddy's death, eventually snapping out of it into a UnstoppableRage. Well, unstoppable by anyone but Carrot, but he's Carrot.
Vimes at the end of Thud!. THAT! IS! NOT! MY! COW!
Rincewind in Sourcery. Finally returning to the Library after Coin orders it burned. What follows is almost tragic, as Rincewind frantically searches through the ashes for anything familiar, sobbing.
Dangerous Beans has one in The Amazing Maurice and His Educated Rodents, after learning the book that inspired him to dream of a world where rats and humans live in harmony, Mr. Bunsy Has an Adventure, is merely a children's storybook by the Discworld equivalent of Beatrix Potter.
Ginger has one of these in Moving Pictures after seeing the creature from the Dungeon Dimensions fall off the Tower of Art. Justified, as the giant shapechanger had taken Ginger's own form (among others) as it plummeted to its death.
Subverted in The Last Hero: When Leonard of Quirm is tasked by the gods to paint the entire cosmos on the ceiling of the Temple of Small Gods, as punishment for building the Kite, Rincewind and Carrot think his silent, inward looking reaction is one of these. Actually, he's just visualising how awesome it's going to look once he's finished.
Near the end of H.G. Wells's The War of the Worlds, while exploring the lifeless ruins of London, and already teetering on the ragged edge of sanity, the narrator comes upon a tripod and a dead Martian inside it. The mixture of exuberance and grief that follows is too much for him to handle, and he only regains his sanity several days later, learning from his caretakers that he was found roaming the streets crying and shouting "last man in the world, hurrah, last man in the world".
Vanyel from the Last Herald-Mage has HeroicBSODs all over the place. The first is in his Super Hero Origin, where the death of his lover and a massive infusion of magical power sends him into near-catatonia, and the last comes after being tortured and using his magical powers to slaughter an entire camp of bandits in the culmination of a Roaring Rampage of Revenge.
For that matter, Tarma and Kethry do this in their backstories, both of which involve rape. Mercedes Lackey employs this trope rather liberally.
Eragon has one of these after he finds out the identity of his father (both times}. He gets better freakishly fast.
Bluestar of Warrior Cats suffers a major BSOD after the extent of her trusted deputy Tigerclaw's treachery is laid bare. She is almost completely withdrawn from the world for the next book, leaving new deputyFireheart to pretty much run the Clan in her place, and in the next book, when Tigerclaw (now Tigerstar) takes over ShadowClan, she loses her mind and begins to see her entire Clan as a pack of traitors. Only minutes before her Heroic Sacrificedoes she finally regain her full sanity.
This seems to have happened to Hollyleaf, just before her "death" scene.
In HIVE: Escape Velocity, when Overlord reveals that all of Otto's unnatural abilities exist because he is a super-clone created for the sole purpose of being taken over by Overlord and used to destroy the world Otto stares at Overlord in horror for a few seconds before Overlord tries to take him over but is stopped by HIV Emind.
In March Upcountry,Prince Roger etc. Mac Clintock discovers a) that his father is a traitor, b) that everybody else already knew this, c) that everyone assumed he knew this already, d) that everyone thinks this is the reason he's such a jerk, and e) his mother sent him away because she distrusted him (for reasons a, c and d). This is why he's stuck on a Death World, and this is also why several hundred people have gotten killed trying to protect him. Understandably, he gets angry, swears at his guards, and trashes his room, causing everyone else to doubt his sanity.
"I heard he called the Empress a bitch!" "No, he called his mother a bitch." "What's the difference?" "One is treason, and the other is just being really, really pissed at your mother."
Rand al'Thor from The Wheel of Time goes through several of these, such as when he hears about the death of Herid Fel in A Crown of Swords.
His worst one happens when he tries to murder his own father in a rage and nearly makes himself bring an end to existence itself. He gets better.
Will from The Goodness Gene slips into this when he discovers that he's a clone of Hitler.
Rowan Mayfair has gone into one of these at the beginning of Taltos, (the third book of the Lives of the Mayfair Witches trilogy) after killing and burying Emaleth, her daughter by Lasher.
Hana and Kip's backstories in The English Patient, when their father and mentor, respectively, are killed. Kip gets one at the climax of the book, when he learns about the bombing of Hiroshima.
Túrin from The Silmarillion and The Children of Húrin undergoes several of these, after he accidentally kills his best friend Beleg, after he finds the grave of the princess who he swore to protect and finally when he finds out that his wife is actually his sister. He kills himself after the last one.
Also from The Silmarillion, Sauron seems to be deliberately invoking this on Finrod Felagund during their song duel, by singing of Kinslaying at Alqualondë.
In Watership Down, the rabbit language actually has a word, tharn, for this state of mind. Rabbits, being small, flighty animals at the bottom of the food chain, have a lot of opportunities in their lifetimes to bluescreen in the face of hopeless danger. Heartbreakingly, this is Truth in Television, as baby rabbits often suffer heart attacks if sufficiently frightened. Poor things.
If Watership Down were just a little more prominent, in fact, this trope might have been named "Tharn." It's shorter.
In The Stand, Stu recalls the description of tharn, realizes he's close to a similar mental state himself, and that he has to keep himself out of that state to have a chance at escaping from the Plague Center.
The eponymous character of The Dresden Files has one at the end of Grave Peril after his girlfriend is partially turned into a Red Court vampire. He arguably has one in Fool Moon as well, when he basically shuts down for a little while due to being completely worn out and despairing because Murphy no longer trusts him and has arrested him for withholding information in a murder investigation, when he had just begun to regain her trust after losing it in Storm Front.
In Turn Coat Harry Dresden uses his wizard's Sight to see the true nature of a skinwalker, and has a BSOD that is awesome in its proportions. He isn't just taken aback or slightly shocked - he loses consciousness, slowly comes to and realizes that he is crying hysterically, shaking uncontrollably, blacking out periodically, screaming non-stop, and is pretty much out of his mind. In a few seconds of lucidity he realizes where he is and manages to stagger to a friend's house that is luckily nearby, all the while counting prime numbers to keep himself sane. It's only after spending an hour in a dark room that he's able to pull himself together.
Even days later he's still shaken by the memory, because anything you perceive using the sight is pretty much hard written into your mind forever, and the Skinwalkers are essentially angel sized bits of pure hate that feed on suffering and fear. The fact that he didn't Go Mad from the Revelation is amazing to say the least.
Harry's mind shuts down for a large chunk of time after a massive spell goes off in Changes. The same spell causes nightmares and mental trauma in anyone even slightly magical on the entire planet.
Richard suffers this in Stone of Tears, from the Sword of Truth series, after finding out Darken Rahl was his real father.
Kahlan has her BSOD moment in the same book when she realizes that Richard will be trapped in the Palace of the Prophets for centuries and she will never see him again. Fortunately, he escapes and reunites with her hours later.
In the fourth book, Temple of the Winds, Richard has to enter the eponimous temple to stop a plague that is ravaging the world. Doing so, however, requires a betrayal on Kahlan's behalf, and Richard arrives at his destination fully convinced that he has no reason to live since his true love has forsaken him.
The fifth book, Soul of the Fire, ends with people of Anderith rejecting Richard's call to join him in the war against the Imperial Order. This is a turning point for his character and for the series, because it helps Richard realize what it is he really fights for, and changes the tone of the following books correspondingly.
Chainfire. Richard is falsely led to believe that Kahlan existed only in his mind, and this extinguishes his will to live until he is reasoned with and convinced not to give up and fight for his values and beliefs.
And at last, in Confessor, after Richard finds a contradiction that he can't explain.
Jonathan Harker, from Dracula, suffers one after his imprisonment in the villain's castle and no wonder. His physical health breaks down right along with the mental, and he doesn't even know if everything he saw was real or in his head until Van Helsing confirms it.
In Stephen King's Pet Sematary, after killing his son, who Came Back Wrong, Louis Creed crouches down in a corner, and sucks on his thumb for two hours. And he doesn't get better; he's really just insane now.
Roland in Wizard and Glass goes to a catatonic state for weeks, after witnessing Susan burned to death.
Mike Jenkins has one after finding out that the young woman he loved was killed on a mission, in Unto the Breach. Granted, this is with a somewhat flexible definition of "hero", given the victim of the BSOD.
Achilles falls into one twice in The Iliad, first after Agememnon steals Briseis, and then again (and more legitely) after his friend Patroclos dies in Achilles's place.
Sinuhe from The Egyptian has several, usually triggered by the death of a loved one or the revelation of a secret.
David has an epic and heartbreaking one when he learns about the deaths of King Saul and his son Jonathan, David's bestfriend. It included David giving himself Clothing Damage, throwing ashes upon himself and screaming out loud that he had loved both of them greatly and never wanted such things to happen.
David has another after his rebellious son Absalom is killed.
It can be said that the whole "prayer at Gethsemane" scene is about Jesus having an Heroic BSOD as he realizes that he's just hours away from dying and only then fully acknowledging what that means for him.
Jesus has another one after John the Baptist is killed.
In the James Bond novel On Her Majesty's Secret Service, Bond's new bride is shot to death within an hour of their wedding by Ernst Stavro Blofeld. Bond does not take it well, and spends the first chapter or two of the next novel, You Only Live Twice in a drunken stupor, slagging off on work and generally acting an uncharacteristic disgrace. It gets so bad that M revokes his 00 number and finally, as one last attempt to shake him out of it, assigns Bond a suicide mission on behalf of their allies the Japanese, a mission that if Bond succeeds will convince the Japanese Secret Service to part with juicy information the British need. It works, especially when Bond finds out the big bad he is going after is none other than Ernst Stavro Blofeld, precipitating a berserk Roaring Rampage of Revenge that leaves Blofeld dead and Bond's mind shattered...
The eponymous protagonist of the short story "Young Goodman Brown" by Nathaniel Hawthorne suffers a crippling Heroic BSOD after he wakes up in the forest, unsure of whether or not the events of the previous night, an occult ritual involving himself, several of his townsfolk, and his wife named Faith, really happened or was All Just a Dream.
In Redwall, Matthias undergoes a short Heroic BSOD when he learns that Methuselah was killed while he was in the loft.
Thematically in Haruki Murakami's novel The Wind-Up Bird Chronicle. Most memorably since the events are described in graphic detail, Lieutenant Mamiya describes himself as living in a functional, permanent Heroic BSOD state after having seen his commanding office flayed to death.
Les Misérables has quite a few... ok, better pick those rare characters who don't get at least one. Valjean has this at least 3-4 times. Then he gets better and saves the day.
In web phenom-turned book/film John Dies at the End, Protagonist Dave and best friend John find themselves in a confrontation with some Otherworld enemies. Dave is behind one of the mask-wearing alternate universe villains and during a struggle, John pulls off the villain's mask. Dave literally describes John's reaction as this trope 'like a computer crashing' or words to that effect. John just goes blank, no screaming, just blank. He recovers in time to join Dave in escaping and the incident is, to date, never referenced again and what John saw is never, ever raised.
Derek suffers once of these in The Reckoning after he breaks Liam's neck, killing him. The fact that Liam was trying to kill both Derek and Chloe doesn't make him feel much better about it. Directly after it happens, Chloe gets through to him by pointing out that even if Derek didn't mean to kill, Liam did. It's not enough to alleviate the guilt, but it's more than enough for Derek to get up and deal with it.
In the Cal Leandros book Deathwish, Niko has one of these when he is tricked into seeing the false image of a dead Cal lying in a huge pool of blood, and goes into a fugue state/rampage, in which he is later told that he'd single-handedly killed an entire zoo-full of dangerous supernaturally-enhanced animals with nothing but his katana.
Kallista Varyl in The Eternal Rose has one when the first godmarked, Stone, dies. Since she can literally feel him get poisoned, starts healing him, then his head gets chopped off... she needs some time.
"His shades flew to a far corner of the room, and became a puddle of burning plastic. Yellow eyes with slitted vertical pupils were revealed. Wet and steaming, face ash-blackened, as far from cool as it was possible for him to be, on all fours in the blazing bookshop, Crowley cursed Aziraphale, and the ineffable plan, and Above, and Below."
Karn the Silver Golem had a BSOD during a scene in Magic the Gathering: Rath and Storm. When he goes to kill the murderous traitor Vuel (Volrath before he was Volrath), he smashes a cart of food in a fit of rage to show his power to Vuel's men. However, the cart toppled over onto an innocent boy and crushed him, prompting Karn's BSOD and invoking a vow of pacifism from him.
Despair and bewilderment shook his voice. The girl murmured pityingly, not understanding it all, but aching in sympathy with her lover's suffering.
Bruenor is in this state for much of Starless Night after the loss of his adopted son, Wulfgar.
In the third Anne of Green Gables book Anne is told that Gilbert (formerly Unlucky, soon to be Victorious Childhood Friend) is dying. She's just returned from a trip visiting friends elsewhere, so she knew nothing of it. Her family wanted to break it to her easily, but a child just let it slip out. Cue a total segfault in Anne's mind. She speechlessly has to go up to her room to spend the night reevaluating everything she thought she knew about love.
In Alexander Yang's Midnight World series Aeneas's BSOD after his wife's death lasted for several monthes. By his own account, it was something like "walking letargy".
In A Song of Ice and Fire, Sansa Stark spends the Red Wedding in this state. She also has another when she starts menstruationg, both because it means Joffrey will try to rape her to produce a heir, and because her cramps were VERY painful
In Little Women, the March ladies have more than one of these.
Beth in the backstory, when her Shrinking Violet tendences went to the extreme and she couldn't withstand going to school anymore, thus her parents chose to homeschool her.
Marmee, when she gets a letter telling her that Reverend March is on the brink of death in the war front
Meg, as she overhears the Gossipy Hens talking about her and Laurie,
Jo, upon Beth's death.
Both Vincent and Malim, in Unda Vosari, have their fair share of Heroic BSODs during the course of their adventures. Vincent ends up talking to himself using parody voices of other characters, while Malim makes hand puppets out of paper and goes completely nuts.
Honor Harrington spends a good chunk of "Field of Dishonor" in one after Paul Tankersley's death. She's just recovered from it in "Flag in Exile when the an industrial accident which killed several schoolchildren, for which she is blamed sends her right into another one. And that doesn't even count all the BSODs that occur during and immediately after the battles in that series.
At the end of Carnifex, Carrera collapses and slips into one of these both from the fatigue built up over the course of a long and hard campaign and the fact that he nuked a city.
Alex Rider: In the final book. After Jack is killed, Alex loses his cool for the first time in the whole series, screaming and crying over the death of the only person in his life who was always there for him. He then, seemingly, gives up, becoming quiet and unresponsive, even when Gunter reveals Scorpia's plan to him. But this turns out to be nothing but a ruse to catch Gunter off guard; he later kills the man and rushes off to save the world once again.
In Death: Eve has experienced this a few times, like in Conspiracy In Death. Roarke definitely had one in Portrait In Death.
In Time Scout, Malcolm takes Margo to Brighton during her special trip to Victorian London. Normally, he doesn't take clients to the beach in February, and when they do go to the beach he usually avoids Brighton. That's because he's from Brighton and his younger brother drowned during The Accident, in February. He has a breakdown and Margo has to keep him in one piece.
Sisterhood Series by Fern Michaels: Oh, boy! Nikki Quinn suffered this in the book The Jury. Maggie Spritzer suffered this in the book Hokus Pokus. Harry Wong suffered this in the book Vanishing Act. Jack Emery helped them out of this in all three instances.
The Idiot has this at the very end. Prince Myshkin's fiancee Nastasya abandons him on the day of her wedding, and instead elopes with Rogozhin (who, for all his flaws, Myshkin still considers his friend and spiritual brother). The next day, Myshkin goes to see them, and discovers that Rogozhin has killed Nastasya. When the police arrive on the scene, Myshkin and Rogozhin are keeping vigil over her body, and Myshkin is now mute and mad. The novel closes with him committed to a sanatorium. In other words a typical Russian ending. There's a reason they invented Vodka.
In the Jeeves and Wooster story "The Aunt and the Sluggard", the aftermath of the latest Zany Scheme forces Bertie to stay in a hotel without Jeeves for an indefinite period. Bertie crashes almost instantly, losing interest in normal activities and even going through a period resembling mourning. He pulls himself together, vaguely, after a few days of this:
The frightful loss of Jeeves made any thought of pleasure more or less a mockery, but at least I found that I was able to have a dash at enjoying life again. What I mean is, I braced up to the extent of going round the cabarets once more, so as to try to forget, if only for the moment.
The Heroic part is kind of doubtful, but Delaney Mossbacher's brain definitely stops working after he hits Candido.
Draffut has one at the end of Sightblinder's Story when he realizes that he has accidentally caused the death of a human being. Since his entire existence had been dedicated to the service, protection, and healing of mankind, this kind of makes him lose his mind.
James has one when someone suggests that he isn't more successful than Dylan.
Dylan himself has one when WARP is evicted from its club-room
Melvyn has these, out of sheer surprise, whenever he says something intelligent. It's suggested that it's deliberate: he knows the next thing he says will be dumb, so he doesn't want to spoil the moment.
Alexia goes into shutdown mode in Timeless after she watches her temporarily-mortal husband fall to his apparent death. She snaps out of it when he does a Big Damn Heroes at the climax of the book.
The Expanded Babylon 5 Universe trilogy of novels, The Passing of the Techno-Mages, has Galen spending a lot of time in this state—frustratingly so, for the reader—when the Technomages exile themselves to sit out the Shadow War. He pretty much cuts himself off from everyone around him, refuses to talk through his issues even with those closest to him, and stoically keeps his anger just below a boil while it eats away at him. Much of this is due to his discovery that Technomage "tech" was created and supplied by the Shadows, a truth that was kept from him even by his close mentor and father-figure, Elric. He finally snaps out of it when he makes his own trip to Z'ha'dum.
In Donald Kingsbury's Courtship Rite, Oelita experiences an extended version when, on top of discovering conclusive proof that her whole belief system is a lie, she finds that the two people she's just fallen in love with are married to the man who has been trying to kill her. She flees to the wilderness to live as a hermit, until the maran-Kaiel decide that surviving this shock counts as the last test of the Death Rite, and decide to bring her back to marry her, since they've learned to love her too.
In Tom Kratman's Caliphate, Hamilton suffers through this when his girlfriend and fellow officer Laurie was killed in a battle in the Philippines.
Tobias has a couple in Animorphs. The first is really early on, right after he's first trapped in morph. He lets the hawk part of his mind take control and stays away from everyone for a few days before finally snapping out of it. Much later, he has one after Rachel's death, flying away with her ashes into the woods and staying away from everyone for a while.
Cassie in The Departure.
Jake in The Ultimate and The Beginning.
Happens briefly to Éomer in The Lord of the Rings during the Battle of the Pelennor Fields, when he learns that his sister Éowyn, who should have been safely home in Rohan, has died (or so he believes) in the battle. Followed by Unstoppable Rage.
"Then suddenly he beheld his sister Éowyn as she lay, and he knew her. He stood a moment as a man who is pierced in the midst of a cry by an arrow through the heart; and then his face went deathly white, and a cold fury rose in him, so that all speech failed him for a while."
''Song at Dawn: After her traumatic first time Estela's love ballads fall flat because she's disillusioned. Dragonetz 'reboots' her, so to speak, after having sex with her himself.
Two different characters each suffer one for almost the entirety of the second book of The Mark of the Lion trilogy: After her husband dies, Phoebe is completely paralyzed and unable to communicate save by way of a code she worked out with her servant. Then Marcus, thinking Hadassah has been killed by lions, spends months so emotionally and spiritually devastated that he is unable to run the family estate and business like he’s supposed to.
In The Host Wanderer has one when she discovers the doc is attempting to remove souls out of the humans. She hides herself away for two days and doesn't talk to anyone.
In Thieves Like Us, Con has one when the bad guys force her to ride in the backseat of the car they're abducting her and Motti in. If that sounds rather silly, keep in mind that when she last rode in the backseat, she was a child and had to see her parents die horrifically in a car wreck (and watch their mangled corpses hang there until she could be pulled out by the paramedics.
She falls apart for a bit after having to kill her reworked lover Dodd. She had asked Fly to do it for her if she couldn't but realized that she'd hate him if he did and chose her living friend over her dead lover.
The second time Arlene breaks down is worse. Dodd was a lover but she otherwise didn't understand her feelings for him. She truly loved Albert and married him. Completing the mission meant returning to Albert forty-years after she left him due to AvertingFaster-Than-Light Travel. Fly's berserk rampage on the Fred ship completely robs her of returning to her husband as centuries will pass before they can return to Earth. She wanders the Fred ship in a daze, her only communication with Fly is mourning Albert, she tortures the dead Freds by using them as target practice, and fires into the bulkheads without caring about a ricochet killing her. The only way Fly can snap her out of it is to walk into her line of fire.
The Last Dragon Chronicles: Lucy was abducted by an evil witch and lived on mushrooms in the Arctic for a few months. When she was eleven. What's one to expect?
In Wonder 2012, August is unintentionally betrayed by his best friend Jack during Halloween, and he assumes this for a while. His sister Via helps him get out of this.
In Frostflower and ThornFrostflower understandably becomes almost catatonic after being captured, raped, tortured, publicly humiliated, and hung up for execution before her daring rescue by Thorn and Spendwell. Oh, and her son was taken away from her. And her dog.
Luxa becomes essentially catatonic when her cousin betrays her.
Vikus suffers a stroke after his wife dies.
In the unbelievably bitter and unexpected ending to Judith Merril's 1953 story "Dead Center", Ruth is described as having a "tired and unholy calm" expression.
Beka has one in the third Provost's Dog book when they find that the slavers and slaves that the abducted young prince had been hidden among have all been brutally slaughtered and left rotting in a field like garbage, this after dealing with many other horrific deaths and cruelties inflicted by the treasonists. She's desperate to find some way to give the poor folk a bit of dignity in death even though they don't have time, and she probably would have broken had not had the Black God suddenly appeared to bury them himself in pity and thanks for all the good service she'd done him.
Gifts: Both Orrec and his father shut down after the death of Melle, Orrec's mother. Orrec calls it the "year of darkness."
Powers: The only reason Gav doesn't throw himself in the river after the funeral of his sister Sallo is because he was too numb to think. It only occurs to him later when he realizes that he probably wasn't pursued because everyone in Arcamand would assume he did.
Chroniclesof Magic The main character, Benjamin, suffers from one of these a couple of times but always manages to recover pretty quickly. His friend Halfrida, on the other hand, seems to be living in this state.