Francesco Dellamorte-Dellamore in Cemetery Man - this is, in fact, the whole plot of the film.
Zac Hobson in The Quiet Earth begins suffering this when he realises that he may very well be the last human being alive. After the Good-Times Montage, he begins dressing in women's clothes; he fills his garden with cardboard cutouts of celebrities; he fires his shotgun wildly at televisions; he declares himself President of the World and gives his inaugural address to the cutouts. And then the power goes out, leaving Zac standing on his balcony, in total darkness and utterly insane. He gets better.
Eric in Killing Zoe wasn't exactly the sanest person to begin with, but doing copious amounts of heroin, murdering several people, and setting off some explosives cause him to become batshit insane. As further proof, one of his favorite threats towards the end are "I'll fuck your bitch up the ass and give her AIDS!"
Stéphane in The Science of Sleep always had rather odd and confusing dreams and Imagine Spots to help his cope with reality... by the end of the film he's unable to tell the difference between the two. While it doesn't go all the way to the end he holds shades of this.
Happens to Komodo in Warriors of Virtue after he kills Master Chun. Although he was pretty zany from the start, he seemed to drop a few notches after the event.
It is a thing to behold when this happens to Alonzo Harris towards the end of Training Day, when he finally realizes that his corrupt methods held no power over anyone any longer, and he was truly going to die.
Although Trevor Reznik from The Machinist had been acting odd ever since he kills the boy, when he starts harassing and assaulting everyone around him in a paranoid conviction that they are all out to get him you can tell he has finally completely cracked.
Mike in Deep End suffers this, mostly courtesy of Susan. The entire plot of the movie is Mike becoming her Stalker with a Crush — except it's rather hard to understand why, considering her personality — and in the end his sanity finally snaps completely and he kills her. Given how she treated him throughout the entire movie, it's hard to sympathize with her.
Gordon in Session 9, although whether it's insanity or some sort of supernatural possession is left deliberately ambiguous.
The main character in I Am Legend suffers the beginnings of sanity slippage, asking a mannequin to talk to him because he promised his dog he'd ask, then breaking down in tears because the mannequin does not answer. It's even worse in the deleted scenes/uncut version. When he drives past the mannequin trap the head of the mannequin actually moves, and when he wakes up after being saved from his suicidal assault, he first sees the people in his house as his own wife and daughter who had died years earlier.
This trope is the whole point of Black Narcissus. All of the nuns find their flaws and emotional weaknesses slowly becoming more and more exaggerated. Things are worst with Sister Ruth, none too well to begin with, who turns into a Stalker with a Crush, and winds up dying a Disney Villain Death when she attempts to murder her superior, Sister Clodagh.
Ursula of The Little Mermaid. While not a good character, she was sane and composed during most of the film. However, when she transforms into Vanessa, its implied that she lost quite a bit of sanity (to the point of becoming a borderline Ax-Crazy) when turning into her, as she talks to her mirror in a manner similar to a schizophrenic, emits a psychotic grin when throwing a pin at a mirror's head with enough velocity to knock the mirror back, and most certainly kill a person had that been a human being, not to mention her cackling.
Alex Forrest in Fatal Attraction grows increasingly unhinged the more Dan Gallagher tries to distance himself from her, until she reaches the point where she's willing to boil his daughter's bunny in the pressure cooker, kidnap her, and then try to knife his wife to death.
In The Assassination of Richard Nixon Samuel Byck (who was a real person) experiences this. Initially he just seems like a slightly delusional loser, but eventually he plans to hijack a plane and fly it into the white house. Not to mention his intentions of killing his boss before that.
In Cross of Iron Steiner goes through this as he's recovering in hospital. Even more so in the ending when he goes into a laughing fit in the middle of battle after Captain Stransky asks him how to reload his firearm.
The documentary Touching The Void is about the two climbers Joe Simpson and Simon Yates in their attempt to climb the Siula Grande mountain. After Joe Simpson has had his rope cut, and has been days without food or water, he eventually becomes delirious; as he presumes himself to be close to death, the song 'Brown Girl in the Ring' by Boney M gets stuck in his head, which is a song that he hates.
In Werner Herzog's Heart of Glass, the death of a foreman glassmaker has deprived a 18th century glass factory of the secret recipe for red glass. The movie is driven by the factory owner, threatened by bankruptcy, progressively losing his already weak grasp of sanity.
In Mulholland Dr. all it took to send the mentally unstable protagonist over the edge was some knocking on the door.
Repulsion is about a troubled young woman stumbling deeper and deeper into madness.
In Shine, David starts off reasonably normal but as time goes on becomes increasingly manic and starts being less intelligible, peaking when he plays Rachmaninoff's Third Piano Concerto and in the aftermath.
In Thor, Loki's sanity starts to slip after he discovers his true Frost Giant heritage. By the time he is fighting Thor at the end of the film, he is on the verge of Laughing Mad and has clearly taken a dive off of the slippery slope. The slippage continues into The Avengers, where it's clear that his fall through the Bifrost has left him Axe-Crazy and more than a little unhinged.
In The Gamers: Hands of Fate, Gary continuously hallucinates horrible things about Chibichan, a Pokemon-esque creature, because its creation brought about the cancellation of one of Gary's favorite shows ever, Ninja-Dragon Riders.
Elysium: Not that he was entirely sane to begin with, but Kruger becomes noticeably more unhinged following his facial reconstruction.
In X-Men: The Last Stand, this is why Xavier had neutered Jean Grey's mental powers to keep the Phoenix hidden. And once she's unleashed...
My Life as a Dog: No this movie has nothing to do with turning into a dog. This movie is about the sanity slippage of Ingemar as he starts acting more like a dog and less like a boy. He's losing everything and compares himself to Laika, the first dog sent into space and left to die. Uncle Gunner is challenged with trying to reach this boy before he's lost forever.
Vampire's Kiss is the story of Nicolas Cage's character, the businessman Peter Loew, slowly becoming crazy, firmly convinced he's turning into a vampire.
Stonehearst Asylum: Lamb. While he his methods towards mental health are humane in and of themselves, he keeps the real staff locked up, puts a homicidal killer like Finn in charge of security and shows no remorse when Finn kills two escaped staff members and later one of the patients, electroshocks Salt into amnesia and tortures Newgate.
In Fury (1936), the hero undergoes a sanity slippage in the third act, caused by the guilt that is weighing heavily upon him. He starts hearing Katherine's voice when watching the shop window, he sees the number 22 on the calendar at the bar and can't help but think of the 22 accused. After he leaves the bar and walks along the street, he sees some of the faces of the mob in a store window. Frightened, he begins running down the empty road as if he's being chased, the camera follows him, only showing the audience what seems to be following Joe - nothing, only his conscience.
Max certainly lives up to his name by this point. He's haunted by voices and hallucinations of the people he's watched die and failed to save over the years, most of all his wife and son, he twitches and mutters to himself often, and he shows signs that he's spent so long on his own that he's forgotten how to interact with people normally. These all point to signs of PTSD and schizophrenia.
On the villainous side, the Bullet Farmer starts out relatively understated and sedate, snarking about how they're committing dozens of cars to a "family squabble". After he's blinded, however, he begins ranting about he's the conductor of the Choir of Death, firing machine guns at nothing just because he enjoys shooting, and referring to his guns as "Brother Heckler" and "Brother Koch".
Reality, is the story of the protagonist's descent into insanity. Although it is hinted that he wasn't particularly stable to begin with.
The central plot of A Woman Under the Influence. Mabel, a psychologically fragile housewife, has a full-on breakdown brought on by the pressures of motherhood and the stress of being married to a mean, aggressive husband. Early in the film she is doing odd things like addressing people who aren't there or calling people by the wrong name. Eventually she's committed to an asylum.
Assassin's Creed (2016): Callum, due to having to be dragged into the Animus the first two times, starts hallucinating his ancestor severely enough to spar with him, as well as going Laughing Mad for a while. There's also the other Assassins who are left catatonic due to being forced into the Animus against their will.
In Assamese anthology horror film Kothanodi (The River of Fables), the character Dhoneshwari descends rapidly into a delusional half-dream state where she imagines the python she married her daughter to is adorning her with jewellery on her wedding night, when it reality the python is eating her.
The Man Who Killed Don Quixote: Javier started losing his sanity when Toby was filming The Man who killed Don Quixote. And it progressively happens to Toby as well ten years later.
Accident: Following Fatty's death (which he is convinced was aimed at him), the Brain begins a rapid descent into paranoia: seeing conspiracy at every turn.
Ms. 45: At first, Thana only kills men who attempt to take advantage of her. Later, as she loses more of her sanity, she kills any man unlucky enough to be near her.
General Jack D. Ripper goes through this as Dr. Strangelove unravels. He sends his base's squadron of B-52s to attack Russia, telling his attache Group Capt. Lionel Mandrake that it's because Washington has been attacked. What Ripper eventually confesses is that he's impotent and that the Russians are responsible for it through fluoridation of the water. Everyone in the Pentagon war room (except, maybe, for General Turgidson) that Ripper went off his nut for pre-empting the failsafe mechanisms the attack plan called for.
In The Hands of Orlac, Orlac's sanity starts to slip from the time he wakes up in the hospital with his new hands. He becomes possessed of the desire to kill and believes that along with the hands he has acquired the murderer's predisposition to violence. He decides he can no longer touch anyone with his hands lest he be overwhelmed by the compulsion to kill them. Things get worse as the movie goes on.
Jungle: Yossi's mental states is slowly degrading almost from the start of the trek into the jungle. However, once he is stranded by himself in the Hungry Jungle, he goes downhill rapidly. At his lowest point, he creates an Imaginary Friend to accompany him.
The Descent is a British horror film about a traumatised woman named Sarah who goes spelunking with some friends in the Appalachians, but then they get trapped in a cave-in. When things go From Bad to Worse and the party discovers that the cave is home to cannibalistic degenerates, the women descend into savagery to survive and Sarah completely loses it.