The biggest is definitely Meyer Lansky. In his first appearance, he's on the receiving end of jokes about being a kid in his dad's suit. Within twenty years, he will be one of the most powerful men in America.
Richard Harrow starts out as a unemployed, disfigured Shell-Shocked Veteran whom Jimmy Darmondy meets in Chicago. He quickly becomes one of Atlantic City's deadliest hit men and in season 3 he pretty much singlehandly ends a Mob War when he pulls a One-Man Army and slaughters more than a dozen armed gangsters within the span of 15-20 minutes.
The show is one long study in this trope for Walter White. In season one he's a mild mannered science teacher living in a near shell shocked state over all the disappointments and missed opportunities in his life, and, unknown even to himself, is secretly enraged by it all. By the end of season four, he's toppled a major drug ring, murdered a LOT of people, and in season five, is the Big Bad of his own story.
Gus Fring. A flashback shows him as a mild-mannered fast food cook on the bottom rung of the drug trade who watches helplessly as the cartel murders his friend and partner. In the present, he's become the ruthlessly competent and dangerously savvy head of an international drug empire.
Liam was just a cheap and fun loving young man, just one of many in the world who would have lead an unremarkable life — until he met a beautiful vampire. Reborn as Angelus, he immediately distinguished himself from other vampires by his sheer cruelty and inhumanity. Even the Master, one of the oldest and most powerful vampires seen in the series, called him "the most savage creature I have ever known". Despite being not much stronger than the average vampire, Angelus always inspires fear and dread whenever he reasserts himself. During his stint as Big Bad he came closer to destroying humanity than anyone else in the series, even the First Evil itself.
Really, this applies to nearly all the Master's line: Darla, Drusilla, and Spike started out as, respectively, a High-Class Call Girl dying of syphilis, a chaste and timid young woman suffering from unwanted visions, and a Momma's Boy who write bloody awful poetry. Who would have expected the likes of them to become a crew of Hero Killers?
Willow went from a powerless, clueless Muggle to the most dangerous member of the Scoobies and probably the most powerful magic user on the planet over the course of six seasons, but didn't become a Nightmare until Tara was killed and she went on an Unstoppable Rage rampage that almost ended with the world ending. Jonathan, having known her almost as long as Buffy and Xander, could hardly believe she was the same person.
Warren Mears at first seemed to just be some pathetic geek living in his mom's basement, until he showed up at Buffy's place with a gun.
Arguably, the From Nobody To Nightmare happened in the episode Dead Things. Before this episode, Warren was presented more like Jonathan and Andrew, i.e. immature geeks trying to act like comic book supervillains, though he had been the only one willing to have a demon kill Buffy in "Flooded" and tried to dissolve her in "Gone" instead of re-visibling her. However, in Dead Things, Warren mind controls his ex-girlfriend, then proceeds to try and have sex with her, and then crosses the Moral Event Horizon by accidentally killing her when she wakes up, then manipulates Jonathan and Andrew into framing Buffy for murder, using magic so even Buffy believes she's the killer. Then he just gets worse from there...
The Mayor. He was originally a mortal human, stumbled across the Hellmouth while prospecting for gold, and made a deal with the demons (which included the founding of Sunnydale on the Hellmouth and his gaining immortality) mainly in order to avoid being killed.
The comic story "Haunted" reveals Adam was just a random, faceless Initiative grunt killed by the Mayor.
Discussed at the end of the episode "Damage" in the final season of Angel. The episode concerns a woman who when she was just a young child, her parents were murdered by a serial killer and she was abducted and tortured by him, literally driven insane. In the present she inherits Slayer abilities and Super Strength, and the result is a rampage with multiple deaths. At the end of episode she's tranquilized and taken by the other Slayers, but Spike is pessimistic about their chances of being able to help her.
Spike: She's too far gone for to help. She's... one of us now. She's a monster. Angel: She's an innocent victim. Spike: So were we, once upon a time.
The Senior Partners, the Big Bads of Angel's spin-off show. Back during the Primordium Age when the Old Ones ruled the Earth, they were, according to Illyria, weaklings who were barely considered stronger than a vampire. In the here and now, they're all-powerful extradimensional beings who pretty much control our world and more from behind the scenes.
In the IDW comic series After the Fall, the various Demon Lords who took over L.A. when the Senior Partners sent the city to Hell were, for the most part, originally just low-level demons who took advantage of the chaos to build their power bases.
The Day of the Triffids: Torrence from 2009's version sees the collapse of society as an opportunity to get himself a nice suit and an army of mercenaries and try to take over the country.
Doctor Who: In the serial Planet of Spiders, the main (human) villain, Lupton, was a former salesman and manager for 25 years who was embittered when his company fired him. So he volunteered to do the bidding of giant spiders, who gave him great powers.
The Master. Before he looked into the Untempered Schism and had the drum beat implanted into his brain, he would just have been a harmless Time Lord child.
The Snowmen reveals that classic Who monster the GreatIntelligence started out as a parasitic lifeform in the form of sentient snow, feeding on the negative emotions of a single misanthropic man for most of his life, until it eventually developed a mind of its own and became magnitudes more deadly.
The Doctor, who is a demonstration of what happens when a member of the most powerful race in the Universe, decides to ignore their non-interference policy, steal a time machine and interfere!
Pretty much all Time Lords have the potential to be this. Even the first one Omega, who, according to Big Finish, started out as a student with bad test results and becomes someone who nearly destroys the Time Lords.
From Big Finish Doctor Who Sebastian Grayle. He was originally a Roman Soldier who didn't have enough money to marry his love. He is given immortality by the Nimons, and after living for centuries, outliving everybody he marries, becomes a bitter twisted figure who helps the Nimon invade Earth. He becomes so terrible that when he goes back in time his past self kills him.
Davros started off as a scared child in a war between the Kaleds and the Thals. He rose to become the Kaleds' leader in the scientific division. He then created a new species from the mutated Kaleds. After he was thrwatred by the other Kaleds, he arranged his own species extinction using the Thals, whom he also attempts to wipe out. The species he creates? The Daleks, a race of omnicidal maniacs that became the Doctor's Arch-Enemy.
Fargo: Lester Nygaard from Season 1 is a local salesman and a Butt-Monkey at the beginning of the show, but develops into this after what ensues when he first meets Lorne Malvo.
Farscape: Namtar was a lab animal given a serum that boosted his intelligence. By the time the crew meets him he's an Evilutionary Biologist who terrifies everyone around him.
Unlike most Peacekeepers, the first-season Big Bad Captain Crais actually grew up on an agricultural commune and was fully expected to spend his life as a common farmer like his parents... up until a Peacekeeper press-gang arrived in search of new recruits. Ambitious and eager to prove himself, Bialar Crais rose through the ranks on wits and hatred - until, by the start of the season, he's in charge of his own command carrier.
The series-wide Big Bad, Scorpius, was born into slavery as the hybridoffspring of a raped test subject. Weak and sickly throughout his childhood, his Scarran captors considered him a failed experiment... right up until he escaped from captivity. Worse still, the attempt to recapture him ended with his "nanny" getting a coolant rodto the eyeballs and a Peacekeeper ambush being called in on her dreadnought. Impressed with his intelligence, Peacekeeper command decided to waive the rules against hybrids and allow Scorpius to join them. By the time the crew meets him, the former slave is in command of a top-secret research facility; over the series, he levels up to commanding his own warship, to commanding his own interstellar experiment, to commanding his own fleet.
The Flash is packed with people who were once nothing but small time crooks or even innocents but then a particle accelerator explosion granted them powers and quite often twisted them.
Leonard Snart was the son of an abusive cop turned imprisoned thief. Pushed to crime himself, he stole a weapon to make himself Captain Cold. Mick Rory was a young pyromaniac turned brutal crook himself who got the other weapon to become Heatwave.
The Mardon Brothers were small-time crooks until they each gained the power to control the weather to the point of nearly burying Central City in a tsunami.
Kyle Nimbus was to be executed but instead gained the ability to turn his body into a deadly gas to kill others.
Bette Sans was a soldier who suffered shrapnel wounds from defusing a bomb. When the accelerator hit her, she found herself able to detonate anything with her hands and became Plastique.
Grodd was a simple captive gorilla who gained hyper-intelligence, powerful telepathic abilities and a hate of the human race.
Roy G. Bivolo was a color-blind artist who gained the power to fill anyone with rage with a look.
Sam Scudder was a crook trapped in a mirror who gained the power to travel through them and use reflections as weapons to become Mirror Master.
James Jesse was a simple crook who became the maniacal Trickster.
Amunet was a flight attendant of all things who put up with regular harassment by her male pilots. When she gained the power to control metal, she killed them and then created a massive criminal empire.
Becky Sharpe was a woman with horrendously bad luck before a burst of dark matter caused her to alter probabilities so only good things happen to her. But to make it work means horrible random events hit anyone around her and the luckier she gets, the worse it is for them.
Clifford DeVoe was a bright man using a device to amplify his mind when the accelerator hit. With his mind expanded to genius levels, he at first wanted to use it to help mankind. But then he discovered that accessing so much brain power was shutting down all his other motor functions and forcing him to life in a nearly paralyzed state. He thus uses his mind to steal the bodies and powers of others and even uses a hyper-drug on his wife to ensure she won't turn on him.
Melisandre, the terrifying Red Priestess with great powers, reveals to Gendry that she was once a slave.
Daenerys rises from a timid bride to a Young Conqueror. At the start of Season 2, she is the leader of only a few dozen ex-slaves, most of which are women, old men, and children; with one knight under her command. By halfway through Season 3, she has an army, dragons old enough to kill, and is feared by the cities of Essos. By the end of Season 6, she is queen of Meereen and has the largest forces by far, ready to claim the Iron Throne.
Daenerys: "A fortnight ago I had no army, a year ago I had no dragons."
Walder Frey goes from a unpleasant but relatively harmless Dirty Old Man to the regicidal lord paramount of the Riverlands without even leaving his chair.
Heroes: Sylar/Gabriel Gray goes from a nebbish clockmaker to Social DarwinistSerial Killer supervillain in a pretty short period of time. Even among other super-powered people, he's one of the most powerful and feared.
House of Cards: Both the original and the U.S. remakerevolves around this trope. Francis Urquhart/Underwood was perfectly happy helping the Prime Minster/President's agenda, so long as he was promoted to the main cabinet/Secretary of State. Then the Prime Minister/President broke their deal, deciding Francis was better use to him as chief whip, a job Francis has held for twenty years. Cue the entire plot of the show, which is essentially Francis casually destroying everything his former "friends" have worked so hard for. All the while carrying a proud smile on his face. Being based on Macbeth, the show gives us the interesting twist of having said nobody to nightmare explain his plots, schemes, and motivations to the viewer, accompanied by a frequent Aside Glance.
Similarly, Stanley H. Tweedle, a technician fourth-class (lowest level) who had been nothing but a complete failure until fate intervened and he became the captain of the Lexx, which had the greatest destructive force in both universes.
Limitless has Eddie Morra. In the original movie, Eddie goes from an out of work author to a financial genius who becomes entrenched in the world of financial giants. Now, he's a United States senator and The Chessmaster who controls the fate of Brian's future.
Not to mention his first introduction. He was very convincing as the innocent Henry Gale, making it virtually impossible for anyone to Spot the Imposter. Then he began to show his manipulative nature that we're all familiar with, starting with stringing Locke against Jack even further which had horrible results.
Hell, the Smoke Monster was just a guy who wanted to escape from his jerkwad mother and sniveling brother. But then he gets pushed too far murders his mother, gets murdered by his brother, dumped in a magic spring, and becomes the mass-murdering Big Bad monster.
Once Upon a Time: Rumplestiltskin. Started out as a cowardly, crippled, wool-spinning peasant; then somebody made the mistake of threatening his son. Cue burning down the Duke's palace, killing an all-powerful evil sorcerer, and taking on said evil sorcerer's power, making ol' Rumple possibly the baddest dude in the fairy tale world.
Regina also would have been a nobody were it not for her ambitious mother. If Regina had had her way, she would have been the wife of a stable boy, her true love.
Regina's mother Cora was this. Twice. She rose from being a poor miller's daughter to a wealthy noblewoman and one of the most deadliest sorceresses in the world. Then again in Wonderland where she rose from being banished there with nothing but the clothes on her back to becoming the Queen of Hearts.
Isaac Heller was just an appliance salesman with dreams of being a famous writer, when he was recruited by the Apprentice to become the next Author, tasked with writing down the exploits of fantasy characters across many realms. Then he decided that just recording the stories was boring, and started rewriting things to be more "interesting..."
Zelena, abandoned by her mother, raised by a kind couple, she seemed happy with her life. Then her "mother" dies, her "father" reveals he never loved her and her quest for answers leads to the truth. Betrayed by her would-be mentor of the Dark One and overcome with jealousy at the sister she feels took what should have been hers, she transforms into the Wicked Witch of the West, a horror of a ruler out for a "goal" she can never meet.
Arthur, a young man with dreams of glory, becoming king but his obsession with becoming the greatest ruler he can be leads him to betray everything he stood for: invading other lands, murder, using magic to warp his wife to be his willing slave and his kingdom to be "perfect" and still out to gain what he feels is his "destiny," oblivious to how he has tarnished what should have been a glorious reign.
Power Rangers Wild Force: Viktor Adler / Master Org. Unlike most PR Big Bads before or after him, he started out as a completely ordinary man - an unassuming scientist with a crush on one of his two co-workers. Then he found the remains of the original Master Org and got much, much worse (without ever developing a split personality like Mercer and Mesogog).
One episode features a world instantly cursed with twice its previous population because of the sliding technology. It's dominated by warlords who control the food supply. They meet one who mentions he used to be a shoe salesman.
In the pilot episode, Quinn is visited by another sliding Quinn, a cocky young man on his eighth slide, who helps him complete the formula for sliding. Many episodes later, Quinn encounters the same alternate version of himself, except his sliding experiences have turned him into a ruthless psychopath who has committed countless atrocities. He still has a tiny spark of humanity in him and wants "our" Quinn to kill him so that he can't hurt anyone else.
Said experiences? Giving sliding technology to a human-like race of underdogs losing a war on their own Earth against humans. Their name? Kromaggs. One of their first actions after learning to navigate the multi-verse is to conquer that Quinn's world.
Smallville: Lionel Luthor was just a dirt poor kid from suicide slums with a set of drunken parents. Then after murdering his parents, he became one of the richest men in the world and the poster boy for Magnificent Bastards everywhere. His son Lex also goes from a privileged child in Metropolis to perhaps the most dangerous man in the world due to the accident that caused his hair loss and his dad's emotional abuse.
Stargate SG-1: The Replicators were built originally as just (semi-intelligent) toys who diverged so far from that original function that they became a Horde of Alien Locusts bordering on omnicidal mania, and eventually, an evil race. Oh, and yeah, not only were they a toy, but they were in fact a toy built by what was essentially another toy, a messed-up android built by a doddering old fool left alone on some backwater planet with nothing else to do.
Supernatural: Crowley used to be a 17th century tailor named Fergus MacCloud who, as Bobby put it, "sold his soul for a couple of extra inches below the belt". Over the centuries, he's managed to work his way up the demonic ranks to head of all deals, and later King of Hell, as well as making his mark as one of the Winchesters most dangerous and persistent enemies.
When we first meet Erica, she's a troubled, skittish epileptic ostracized by the entire school. Then Derek gives her the bite. Who's Laughing Now??
Torchwood: Miracle Day: Oswald Danes was just your average, run-of-the-mill sex offender on death row until everyone in the world lost the ability to die and everyone saw his lethal injection fail on live television. He was then recruited by an evil corporation as a spokesperson to help promote their corrupt agenda because vile though he is, Danes is a well-known figure and very charismatic. His Karma Houdini bites him in the ass however when the corporation reveal that he has outlived his usefulness and he goes back to being a nobody. On the run. From everyone.
True Blood: Bill Compton was just a random and lost confederate soldier dying of starvation as he tried to make his way back to Bon Temps to reunite with his family, who didn't even know if he was still alive. Cue one meeting with a lonely widow in a cabin deep in the woods and he was transformed into a vampire by the sadistic Lorena. He still remains somewhat of a nobdy for about a century after this until he is recruited by Nan Flannagan to be a spy for the American Vampire League and the Authority. A succession of seasons later, and he has become first the King of Louisiana to replace the fallen Sophie-Anne, a Chancellor of the Authority after Roman's demise, and now...a Humanoid Abomination that is the physical avatar of the vampire goddess Lilith.
The Wire: Young drug kingpin Marlo Stanfield just starts out the third season as a small-time player with a few corners, albeit ones that are considered prime territory for a dealer. His first appearance is about 10 seconds. Due to the arrest of his competition at the end of the season, he has taken over by the end Season 3. In the fourth season, the police see him as just another drug kingpin like the one before. By the end of Season 4, they start finding the bodies of his victims in row houses. A lot of bodies. Turns out Marlo is the most murderous, ruthless, and sociopathic man to ever run a drug empire in Baltimore.
The X-Files: Billy Miles is one of these. In the pilot episode, Billy is only a poor young man abducted by aliens. And this is the last we think we see of him. Seven years later, he is abducted again, is returned with an alien virus, and turns into an indestructible killing machine, bent on murdering Scully and her unborn child.