From the action film The Incredibles, Mr. Incredible has a brief one when he thinks his family is dead.
From the CGI movie TMNT, Raphael confronts Leonardo, breaks his swords and beats him for once - leaving him vulnerable when the Big Bads gang up on him and capture him. The realisation that this was all his fault turns Raphael into a babbling, incoherent emotional mess.
The Beast has a near suicidal maverione after he lets Belle return to her father.
Mulan completely shuts down after her cover is blown and doesn't boot back up until a handful of Huns prove themselves not quite deceased
In Disney's The Great Mouse Detective, Basil snaps after falling for Ratigan's Evil Plan, silently and stoically sits through the To the Pain lecture, and just waits for the Death Trap to go off, feeling completely humiliated, outwitted, and defeated. Since this is a family film, he gets better.
Dawson: Dash it all, Basil! The queen's in danger, Olivia's counting on us, we're about to be horribly splatted, and all you can do is lie there feeling sorry for yourself!
In Toy Story, when Buzz Lightyear finally realizes he's just a toy.
In Brother Bear, this trope happens when Kenai finally listens to Koda's story about his mother and realizes it is about the fight he and his brothers had with a bear. Kenai puts the pieces together and realizes to his horror that he killed Koda's mother. At that, Kenai flees the bear gathering in profound fear and shame.
In Pinocchio after Pinocchio turns out to be a hit at Stromboli's puppet show, Jiminy Cricket temporarily winds up getting in a state where he feels he's failed as a conscience and believes the little wooden boy would be better off without him.
In Hunchback Of Notre Dame, Quasimodo goes into a depression when his attempts to rescue Esmeralda have allowed Frollo to capture her and Phoebus. When Frollo has him chained to the belltower of Notre Dame, the hunchback can only remark how it's All My Fault as the gargoyle trio try to rouse him;
Victor: But you can't let Frollo win!
Quasi: He already has.
Hugo: So that's it? You're giving up?!
Laverne: These chains aren't what's holding you back, Quasimodo...
Tiana in The Princess and the Frog after seeing "Naveen" (actually Lawrence, transformed with blood magic) ready to marry Charlotte.note If she had thought about it rationally, she'd have remembered that it was impossible to break the curse on Naveen without also breaking it on her, so it couldn't have been the real Naveen. She runs into the French graveyard and sits down on a tombstone, completely depressed. When Ray tries to cheer her up, she accidentally breaks his spirit as well.
Pocahontas after Kocoum's death and John Smith's capture, but she remains remarkably calm about it.
Po throughout most of Kung Fu Panda 2 when he starts having visions about the night his parents were murdered. He eventually comes out of it when he stumbles across the ruins of his Doomed Hometown and comes to terms with the tragedy.
Tommy Pickles hits this spectacularly in The Rugrats Movie when Phil and Lil abandon him and his brother Dil in the woods, Chuckie following them, and Dil's greediness leading to his favorite blanket being torn in the middle of a cold and raging storm.
The title character of Rango suffers this after the villain (actually The Dragon) employs Break Them by Talking. He wanders alone into the desert, and has to receive guidance before he can pull himself together for the final showdown.
In Epic seeing MK Leafman-sized is the breaking point for Professor Bomba, where he realizes he must have hallucinated and how far detached from society he is. He turns off his cameras and packs up or outright throws his equipment off tables in a rage.
Film - Live Action
Jasmine in BlueJasmine, that is if you actually consider her a hero of any sort...
In Braveheart, William Wallace has one of these when he finds out that Robert the Bruce was working with Edward Longshanks. It is enough to where he lies down to almost get captured by a band of English soldiers before the Bruce lets him go. At the same time, when Robert the Bruce realizes the horror on Wallace's face, he looks as if he is about to succumb to one as well.
In Ferris Bueller's Day Off, Cameron seems to have one of these when he sees that the valet took his father's car - his most prized possession, for a joyride. He screams at the top of his lungs for the whole city to hear, then lapses into his BSOD. Ferris and his girlfriend Sloane try desperately to revive him, which culminates with the two of them in a hot tub, and Cameron on a folding chair at the end of a diving board. He falls (or jumps) in, and Ferris "rescues" him, reviving him from his cataplexy in the process. He reveals that he wasn't really catatonic the whole time. Sloane then asks if he saw her get changed, which he replies to with a grin.
Sleepy Hollow used it twice, first when Ichabod first sees the "monster" ("It was a headless horseman. But it was a headless horseman. No, you must believe me. It was a horseman, a dead one. Headless.") and then at the finale: the Horseman brings Lady Van Tassel with him to the underworld, her hand is stuck at the roots of the "tree portal". The hand closes. Ichabod promptly faints.
John "Scottie" Ferguson gets one of these in Vertigo that lasts long enough for him to be put in a mental hospital after the woman he loves is killed. She comes back later.
In The Dark Knight, Harvey Dent. Pretty much all the scenes in the hospital after he finds out what happened are just him on his bed, staring blankly at the ceiling. Of course, you either die a hero, or live long enough to see yourself become the villain...
Barbossa (arguably this rather than a Villainous Breakdown, given his brief stint as a "hero" in the third movie) has one in the third movie, after his plan to save the pirates by releasing Calypso fails miserably. Upon seeing the maelstrom that the Pearl is forced to weather, he just stands on the deck staring at it, before Elizabeth snaps him out of it by reminding that he's needed at the helm.
Jack also gets one when just as he prepares to stab the heart, Davy Jones fatally wounds Will
Norrington in the second movie.
Night of the Living Dead: Barbara has one after seeing her brother killed by a zombie, then being chased across the countryside by said zombie. She recovers almost the whole film later, when her brother leads the mob of zombies that kill her.
In the Korean action movie Shiri, the main character has a bit of a BSOD when he discovers his girlfriend is in fact a North Korean assassin.
Ditto the Korean thriller Oldboy, where the main character BSODs hardcore (AND dumps core, and probably files a cosmic bug report) when he finds out he's been manipulated into sleeping with his own daughter as karmic payback for talking too much about a schoolmate who got his own sister pregnant.
Done pretty well for a comedy in Tropic Thunder, when extreme method actor Kirk Lazarus is called out for his methods, used because he's afraid of what's deep inside, by a rather insane Tugg Speedman (who's suffered his own BSOD after accidentally killing a panda, then supposedly "found a family"). It takes the Only Sane Man, resident geek, and Promoted Fanboy (of sorts) Kevin to shake Kirk out of it...and, well, he attempted to do so with Speedman.
Su in True Legend suffers a catastrophic crash midway through the movie as his wife dies shortly before being rescued. Long story short, he doesn't pull out of it, thus becoming the mythic Beggar Su.
The Expanded Universe events of the franchise also hint that he continuously suffered from the BSOD even after getting his hand replaced.
In Revenge of the Sith, Obi-Wan Kenobi slowly falls into one as he and Yoda see the full extent of the massacre in the Jedi Temple. He's tipped over the edge when he sees a hologram proving that Anakin is responsible but, being Obi-Wan, manages to keep going and fight the man he's loved as a brother. He finally lets his emotions come out after he's defeated Vader and, although he keeps going, it's clear from that point onwards that he's tipped over the Despair Event Horizon. Even nineteen years later, it's clear that he hasn't fully recovered.
In the Bollywood movie Pukar, the main character, Jai, goes through this after having been wrongfully accused of treason and facing court martial. Made all the worse that his girlfriend has left him and his family has been shamed. Ironic, that the only one listening is the person who put him in that predicament (though she never thought it would go so far) and her father. He gets better.
Sarah Connor Blue Screens in Terminator 2: Judgment Day upon seeing a Terminator very much identical to the one that persistently tried to kill her in the previous film. Complete with slow motion, deer in the headlights look, and catatonia, which contrasts nicely with her put-on catatonia earlier in the day after she's shown photos of the Terminator walking around a shopping mall. She couldn't even fight back the orderlies who are subduing her - the same orderlies who were getting their asses kicked by her a few minutes ago.
Pitch Black. When Riddick tries to make Fry leave Imam and Jack behind on the dead planet or he'll leave all of them she calls him out on his manipulation, but breaks down into an unresponsive, crying mess in front of Riddick when she realizes he's dead serious, torn between trying to save herself or die trying to save the others.
At the end of Warrior King, Tony Jaa has a pretty epic Heroic BSOD when he sees the skeleton of his father's elephant (which he has been trailing all film) behind the throne of the big bad and collapses to the ground, getting kicked in the head repeatedly while he reboots, before unleashing the mother of all Unstoppable Rages on every last motherfucker in the room.
The character Sarah has one of these about two thirds of the way through The Descent and doesn't come back for the rest of the movie. On the upside, her BSOD is veryhardcore, and in all likelyhood it saved her life in the American version with the revised ending.
Upham gets one, being only able to walk among the carnage. The Germans realize his condition and never shoot him, even though he has loads of bullets around his neck. He gets over the BSOD only after The Cavalry arrives.
Captain Miller has one upon arriving on the beaches of Normandy. What's even more interesting is you get to see it through his eyes as it happens.
In Space Camp, Katherine (played by Lea Thompson) has one of these after finding the manual override switch. Katherine didn't know whether to pull the switch so they could save their camp counselor Andie (played by Kate Capshaw of Indiana Jones and the Temple of Doomfame infamy), or not pull it and allow mission control to bring them back to Earth on auto-pilot (they were low on oxygen). It eventually takes Kevin (Tate Donovan) who previously "didn't ask to be responsible" to do just that and pull the switch to rescue Andie.
This typically happens in the TV moviesLifetime airs (some they made themselves, others not) when either the main protagonist (or any other character for that matter) discovers some horrible (or otherwise shocking) Reveal in whatever the context happens to be in at the time. It's happened so often that it has now become a stereotypical plot element in such movies.
In District 9, Christopher is purely interested originally in getting himself, his son and maybe a few others the hell off Earth. However, when he and Wikus raid MNU's lab, he enters this state realizing the horrifically evil things being done to his people. Once he snaps out of it, he is now dedicated to return to both free his people and help Wikus.
Star Trek: Generations. Done as only Patrick Stewart can deliver. After receiving word of his brother and nephew's deaths, he keeps a stiff upper lip for much of the movie, but in the immediate aftermath is very curt with his senior staff and delegates to Riker many of the duties regarding the observatory rescue operation he would normally handle himself. A typical Red Shirt might not notice anything wrong with Picard other than maybe he's having a bad day (which is both true and a massive understatement), but Riker and the others gather some inkling that something is very wrong. It eventually gets even worse when Soran says something that calls back to the event of their deaths ("Time is the fire in which we burn.")
Star Trek Into Darkness. Kirk suffers two of them, first when Christopher Pike strips Kirk of his command of the Enterprise and second when Harrison kills Pike during the attack on Starfleet Headquarters.
Ghostbusters gives us another lovely quote after the team has viewed the transformation of Gozer into the Stay Puft Marshamallow Man.
Peter: Ray has gone bye-bye, Egon. What have you got left?
Egon: Sorry, Venkman. I'm terrified beyond the capacity for rational thought.
In James Cameron's Titanic, Captain Edward Smith has a mental breakdown following the ship striking the iceberg and has to be strongly encouraged by one of his officers to give the order to abandon ship. This scene is historically accurate as the real-life Captain Smith actually did suffer a mental breakdown and was only briefly brought out of his stupor by his first officer shouting at him and asking if they should start putting women and children into the lifeboats.
In Greedy, Danny McTeague gets a very bad, but brief, BSOD after getting a gutter ball that ruins his chances of getting into the finals of a bowling tournament.
The Hurt Locker, in following an Army EOD team in Iraq, gives us an escalating scale of BSODs through all the main characters:
James is basically a walking BSOD through the entire film, with some moments shoving him deeper in than others. Arguably, he only manages his reboot at the end of the film when he realizes he genuinely enjoys his ridiculously dangerous job despite his wife and son waiting for him at home, and re-enlists to go back.
Sandborn is pretty stable, but he eventually swerves right into a BSOD when being around James gets him thinking that if he dies, there isn't anyone in the world who would care except his parents. They don't count.
Eldridge goes through several traumatic experiences starting from the very first scene, to the point where he has a counselour popping up around him every now and then. Eldridge actually tells him, sincerely, that he appreciates his efforts and that he feels better having someone to talk to. Then the counselour is killed, and Eldridge is indirectly responsible. Then he's shot. He has precious little sanity left by his last scene.
In Return to Oz, Dorothy manages to endure a lot, including the destruction of virtually everything she ever loved about Oz, but with a lot of hastily-revised plans and some helpful friends, she remains stable. However, when the Nome King transforms the Scarecrow into an ornament and abandons her in a chamber deep inside his palace, Dorothy finally bursts into tears. After a Pet the Dog moment from the Nome King and then a Kick the Dog moment, she falls into a period of despair which she finally recovers when she beats the Nome King at his own game.
United 93's entire cast (besides the passengers aboard the titular flight) suffers one after United 175 smashes into the South Tower.
Katherine, the protagonist's love interest in Fury, has one after seeing an angry mob burn her fiance alive. He gets better. Afterwards she's unable to speak, and has a post-traumatic freakout whenever she sees fire (including people lighting their cigarettes).
Cemetery Man. Learning the rest of the world doesn't exist for you because you're not real could do that to anyone.
Towards the end of Boogie Nights, there's an extended shot of Dirk just staring into space. Somewhat of a subversion, as this is more due to his cocaine addiction, and all the shit that's going on around him.
In The Howling, Karen White suffers one her first time back on TV after being attacked by Eddie Quist.
In Predator, the character Mac suffers one after seeing Blain get killed by the Predator (and actually seeing the Predator for the first time). Only Dutch can reboot him by yelling "Sergeant!".
Maverick in Top Gun likely takes the cake for having a BSOD in the middle of a two vs six aerial dogfight. After flying into an enemy fighter's jet wash, he is reminded of his friend's death after which he mentally shuts down for a few seconds. However, being that aerial combat is a fast, furious affair that requires quick reflexes and a pilot's full attention, it is miraculous that our protagonist wasn't instantly blown out of the sky.
Not sure if he counts as a hero, especially considering the events immediately following this scene, but Philip Seymour Hoffman's character has an epic one in Before the Devil Knows You're Dead after his wife leaves him and reveals she's been sleeping with his brother. He calmly and systematically dismantles their apartment, pouring their decorative marbles over the coffee table and tearing up his entire bedroom. And then shit really hits the fan.
In The Last Temptation of Christ, Jesus has been rescued from the Cross by his guardian angel (in the form of a little girl). He has married Mary Magdalene, and is raising a family. He has his BSOD when his former disciples reveal his ever-present guardian angel as Satan, having sabotaged his dying for the sins of the world. Fortunately, It Was All Just A Dream or Satan's tempting fantasy.
In The Passion of the Christ an enmotionally exhausted Mary embraces Jesus after he has been taken down from the cross ... and is too spent to do anything but give the thousand yard stare.
In Lawrence of Arabia, the title character has a few of these, most notably after he's captured and beaten (and, by implication, possibly raped) by Turkish soldiers.
Both Wellington and Napoleon are in BSOD mode pretty hard after the titular battle in waterloo. Wellington has won the battle but at tremendous cost to his army, and only after having seen most of his aides and officers killed. Napoleon meanwhile is broken by his loss, and the knowledge that dismal exile is the only possible fate for him now.
In Memento, this has happened to Lenny- permanently.
In Little Women's The Film of the Book (more exactly, the classic one of the 40's), Beth has a huge one when she and Amy sneak into the Christmas Party and overhear the Gossipy Hens speculating about Marmee's "plans" of marrying either Meg or Jo off to Laurie. This is parallel to the book scene where Meg is the one who has such an experience and keeps self cool for a bit, then breaks down crying when she's alone.
Creepshow has a rare literal example. The screen actually turns blue behind the hero.
Thor goes into one when he discovers that he can no longer lift Mjolnir. Also Loki visiting him and lying to him that their father had died and that he was banished from Asgard forever.
Odin too could count since Loki's discovery of his true ancestry and resulting outburst caused his powers to shut off.
Frodo has one at the near end of Lord of the Rings: The Fellowship Of The Ring. Frodo just stares with the Thousand-Yard Stare on the river from the shore while holding the Ring on the open palm of his hand, obiviously traumatized by Gandalf's death, Boromir's corruption and the Uruk-Hais' sudden attack, and thinking back when he told Gandalf that he wished that nothing of the events would have ever happened. He snaps out of it when he remembers Gandalf's answer and decides to continue to Mordor.
Robert Neville (played by Will Smith) goes into one in I Am Legend after being forced to kill his vampire-infected dog, who had been his only companion for the three years that had elapsed since the beginning of the vampire apocalypse, in self defense. The following shot of Neville sitting in his car after burying the dog's body and blankly staring at the now empty passenger seat really drives home the point. His depression gets to the point that he attempts suicide by vampire. He gets snapped out of it after being saved by a pair of other human survivors.
Gomez enters one after he loses his fortune and is evicted from his home in the first Addams Family movie. Thing snaps him out of it just before the climax with a three word message: MORTICIA IN DANGER.
Sam from Transformers suffers one in the second film when Optimus dies. And again in the third film when he sees the Autobots' ship destroyed by Starscream and believes the Autobots are dead. Also, various bystanders are shown to be standing speechless or sitting dejectedly after Chicago's invasion by the Decepticons and even Epps and NEST soldiers gave up and declared the fight over. They fortunately snap out of it when Optimus and the rest of the Autobots came back.
The Fifth Element: Leeloo descends into despair as she sees humans' inhumanity to their fellow humans, almost losing it completely when Diva is killed, and then decides to read up on the "WAR" section of the dictionary. This becomes an important plot point almost immediately afterward, as she initially refuses to save the universe if war and violence are all it has to offer.
The third Rocky has Rocky fall into one after both his humiliating defeat to Clubber Lang as well as Mickey's subsequent fatal heart attack, causing him to completely lose his fighting spirit for a good portion of the film until Adrian is able to rouse him out of it.
In Stage Door, Terry suffers one right before she goes on stage opening night when she finds out Kaye killed herself because she wanted Terry's part. However, because The Show Must Go On, she pulls herself together enough to give a great performance.
James Bond has one in Skyfall after he's declared dead after being shot and falling off a bridge during a mission. He debauches himself most thoroughly, but he's clearly depressed.
In Dogma, as explained by The Metatron, this is the reason for the unexplained gap in Jesus's life from the time he was twelve, until his thirties. When told he was the son of God, and was doomed to be betrayed by the very people he was trying to help, it triggered a two decades long BSOD.
By the end of the second installment of The Matrix film trilogy, Neo averts a BSOD at the revelation that there have been previous Ones and that the Prophecy was just another Machine control. But when Morpheus hears a part of this news (combined with his hovercraft being destroyed moments later), he doubts himself, becoming nearly ineffective throughout the last movie of the trilogy, regaining his faith when the Machines stop their relentless attack on Zion at the last minute, indicating that Neo was intervening elsewhere.
In (500) Days of Summer, the main plot of the film is to see how Tom Hansen is handling his breakup with Summer Finn, and looking back to see what he did wrong. He... doesn't take it well.
Jackie Robinson gets one in 42 after enduring a barrage of racial epithets from Philadelphia Phillies' coach Ben Chapman.
In Iron Man 2 Tony goes into one big time, due to him suffering a slow death due to Palladium contamination. It culminates into him throwing a party, completely drunk, while in his Iron Man armor.
Doc goes into one in Back to the Future III after he loses Clara by trying to tell her he is from the future and she doesn't believe him and slams the door in his face.
And in Part II, Marty has a huge one in 1985-A when he finds his father's grave.
In Film/Superman, our hero finds... oh wait... anyway, he finds Lois dead, carries her body to the ground, shakes his head, and screams to the heavens!!!
Then there was Man of Steel wherein Supes okay, contrary to what people say, they DO call him "Superman," but in any case, he snaps Zod's neck and screams in emotional anguish.
Pacific Rim: "Chasing the rabbit", as it is called, where a pilot gets distracted by a memory and loses focus with reality. Mako almost vaporizes the entire facility when she gets attached to a traumatic childhood memory.