Rift, who was a postal worker who lived simultaneously in the DC Universe and the Dakotaverse. When he became Rift, he treated both universes as playthings.
Dr. Hank Henshaw was basically a gag Expy of Dr. Reed Richards in a forgettable Superman comic in which a group of scientists become Fantastic Four Expies - but don't survive the radiation. Well, Henshaw survives, and becomes the Cyborg Superman, one of Superman's most powerful enemies.
Also from Superman, the monster Doomsday, who killedSuperman. It is eventually revealed that he was created through forced evolution on a random, harmless, adorable baby, turning it into a superstrong immortal killing machine.
John Dee, aka Doctor Destiny, was a minor JLA villain who washed up and got locked away for years... until becoming a global threat overnight, leading to a showdown with the Lord of Dreams himself.
...Which was inspired by what Alan Moore did in his Swamp Thing run with the Floronic Man, who realizes that with his control over the growth of plants, he can choke the world any time he wants.
Dr. Light. Turns out his harmless joke status was caused by an accidental magic lobotomy, and that his original personality was a lot morethreatening and now that he's beaten the effects he's a lot more dangerous. Creepiest bit, as brought on by way of retcon, is that for the years in between the League's been letting teenagers fight him without letting on how depraved he really is. His preference for rape has been so Flanderized to the point that many readers have begun to refer to him as 'Dr. Rape'.
The Joker. Whether he was in fact a failing stand-up comedian or a two-bit criminal in the beginning, his One Bad Day turned him from Joe Blue Collar Average into a horrific monstrosity that frightens other villains. Particularly interesting in that he never gained any actual superpowers (other than an incredible resistance or immunity to poisons and toxins), instead deciding it'd be really funny if he concentrated all his efforts to racking up a bodycount that'd make an Evil Overlord blush.
Killer Moth was incompetent and weak. Then he made a Deal with the Devil to become "feared," and Charaxes, a man-eating Human/Moth hybrid, was created.
Mr. Freeze was once a cryogenics scientist who just wanted to cure his wife's fatal disease. One nasty accident later and he becomes a vengeful, emotionless supervillain.
The Penguin was little more than an unpopular child who was teased by other kids because of his appearance. When his mother died, her long illness costing him so much that the bank foreclosed on the family business, he turned to crime, only to be mocked by criminals too. This caused him to find some backbone that he never realized he had, stand up for himself by taking over a criminal gang by force, and eventually become one of Batman's greatest enemies.
The Scarecrow started out as a lanky, bullied bookworm. Wanting to turn the tables, he began a lifelong study of the psychology of fear. Later on, he began experimenting with the physiology of fear, becoming a maker of literal Nightmare Fuel.
For a while, people thought that Scarecrow wasn't much of a threat without his Fear Gas. Then he went out on a killing spree sending the city into the a state of panic causing some of the villains in Arkham to beg Batman not to bring Scarecrow back to the asylum.
IDW's Transformers comic, Megatron Origin details the origins of... Megatron. The evil warlord that has terrorized the Galaxy for countless eons... was once a miner earning dirt pay who got laid off, didn't take it lying down, and was arrested for killing a security officer in self-defense. Later issues reveal that he was also a staunch opposer of Cybertron's current government regime but was never able to get his message across because of his peaceful, nobody nature. Then he got pissed, built and attached a fusion cannon to his arm, and the rest was history.
The Comics further show that the Decepticons had to come from somewhere, and the corrupt government had many of the Cons coming out of the Lower-classes. Of the Big Three: Soundwave was a vagrant with no memory of his past, Starscream was a test pilot, though it's downplayed with Shockwave who was actually a prominent senator who was Punished for Sympathy and had his emotions stripped from him, becoming the un-empathetic Mad Scientist he is today. All the other cons had mid to low level jobs, Blitzing was a security officer, Needlenose was a salesman, Rumble and Frenzy were miners, though this is inverted with Drag-strip who went from a famous racer to a fairly low-level Decepticon.
One of the biggest examples from Marvel Comics is Galactus, the Devourer of Worlds, who began his life as a simple mortal explorer trying to figure out what was going on as his universe ends around him... after merging with the cosmic egg, he is reborn in the new universe as one of the nigh-omnipotent embodiments of existence, feared throughout the entire universe by every civilization that knows he exists.
Black Hand was a C-list villain (based on Batman co-creator Bill Finger) who stole energy from the Green Lantern and based his persona and crimes off of in-jokes and folk sayings. At one point he gave up supervillainy to run a porno theater. He then led the Black Lanterns, and was a primary antagonist in the DC Crisis Crossover, Blackest Night.
Captain America's Arch-Enemy the Red Skull started his life as a poor starving orphan named Johann Schmidt. Growing up in post WWI Germany as a petty thief, he eventually landed a job as a bellhop in a classy hotel. One day, he was performing his duties as a bellhop when he happened to be in the same room as Hitler himself while the latter was berating an officer. After seeing Schmidt, Hitler exclaimed he could turn the bellhop into a better Nazi than the officer. He did.
Speaking of Nazis, Max Eisenhardt was just a poor boy who had the terrible luck of being born into a Jewish family in Nazi Germany. After a truly tragic Start of Darkness that started in the Death Camps and ended in an America entrenched in racism, Max is no longer a boy but a very angry man who not long ago discovered he possesses incredible powers. He's also assumed a few aliases along the way; the latest one? Erik Magnus Lensherr, a.k.a. Magneto.
In Wanted, Wesley Gibson started out as a weak-willed and pacifistic individual and eventually becoming a monster with his father's Improbable Aiming Skills. This was all masterminded by his father, who hated how Wesley's mother raised him and wanted him to "man up" by embracing his supervillain heritage. Arguably the film version is a less evil variation, where Wesley just becomes a Badass instead.
One memorable twist in Larry Hama's run on the G.I. Joe comic book was revealing that the Cobra Commander was... a used car salesman driven to madness by personal loss and misfortune, who built his terrorist army through propaganda and the proceeds from Amway-style pyramid schemes.
Then there's Lex Luthor, who grew from a kid in Suicide Slum (or Smallville, depending on when you started reading Superman) to supergenius and probably the single richest, most powerful, and corrupt businessman in the entire DC Universe.
Blackest Night reveals that the Entities, the embodiments of Hope, Compassion, Greed, Fear, Willpower, Love, and Rage, were originally the first lifeforms to feel those particular emotions. Parallax, the one responsible for Hal Jordan's Face-Heel Turn which nearly wiped out the universe in Zero Hour... used to be an ordinary little bug.
Which also counts as Fridge Brilliance, as Parallax is the embodiment of Fear; what creature would be more likely to be afraid than an insignificant little bug?
When the Spot returns in Amazing Spider-Man #589, he has been driven insane after being trapped too long in his spotted dimension and starts killing mobsters for shooting his son. He uses his powers in surprisingly ruthless ways, makes Spider-Man punch himself in the face◊, and almost succeeds in killing a Russian mob boss. He only fails because Spidey talks him out of it.
The Jackal: Biology professor who fancied Gwen Stacy.
Green Goblin: There have been three villains with this name - an inventor and businessman, a college student, and a psychiatrist. The third, however, did prove to be ineffectual.
The first Hobgoblin, a villain modeled after the Green Goblin, was a fashion designer. For a while, he had a mild-mannered reporter brainwashed to pose as the Hobgoblin as well. This trope was averted with the second Hobgoblin, however, who was a previous mercenary and supervillain Jack O' Lantern.
The ultimate Big Bad of the CrossGen multiverse, Charon of the Negation Universe, was an ordinary archaeologist who had the good(bad?) luck of discovering Atlantis and its Ascension technology. When his comrade Apollyon activated it, they were both flung into the Negation Universe as partially ascended near omnipotent godlike beings. Charon became so powerful that the mere fragments of his madness which he expelled from himself became twisted Eldritch Abominations called the Lawbringers that are powerful enough to fight and killThe First and Sigil-Bearers.
In his first appearance in Captain Britain, Mad Jim Jaspers was a gimmicky Harmless Villain who ended up effortlessly trounced by the Captain and completely forgotten about. A few issues later, he reappears and unleashes his reality-warping powers, conquering first Earth and then the entire universe, bending it to his twisted will and reducing its inhabitants to utter insanity. And Captain Britain is powerless to stop him.
The Human Flame from The DCU is a subversion. True, he started out a pathetic D-list villain that gained incredible power during his mini. The subversion is that, even with a huge power boost, he's still pathetic.
Abraham Pointe was a creepy nobody photographer stalking a waitress in a Las Vegas casino. Then he got possessed by the Predator, the Entity of Love, and became a superpowered stalker.
Eli Bard from X-Force went from a soldier to a respected Roman senator - until his wife stabbed him in the back. After that he went from a destitute ex-senator to vampiric monstrosity who not only commits mass murder but manages to overpower some other genuinely badass individuals.
Scourge The Hedgehog from Archie Comics' Sonic the Hedgehog is most definitely this. In his own words, he was an evil alternate dimension counterpart of Sonic, who was nothing but a minor annoyance. It was only when he became super-charged with energy from the Master Emerald that he became a monster - to the point where he actually took over his home planet just because he could. It's also implied that he's a Self-Made Orphan.
Chaos started out as a Drakon Prosecutor from ancient times, during the war between the echidnas and the Drakon Empire capture by echidnas not long after its imprisonment, a squad of Drakons attacked the camp in order to take back the Chaos Emeralds that the echidnas had stolen from them. During the fight, a discharge from a Prosecutor's battle-staff struck the Chaos Emeralds, causing the Emeralds to 'leak' pure Chaos radiation. The energy mingled with the water in the tank containing the captive Prosecutor, which absorbed the energy and was mutated in a terrifying monstrosity, the creature Sonic would come to know in the future as Chaos.
The Cirinist from Cerebus were originally a group of mothers who worked together to help their community. Over the course of the first 1/3 of the series they go from a creepy Monster of the Week to a major political party to an oppressive matriarchy and eventually the closest thing to a Big Bad the series has.
New Joanne was originally a writer for a religious magazine but by the end of the series she runs the oppressive matriarchy that rules the world and is arguably worst than the Cirinists.
Vandal Savage was just an ordinary caveman before he found the meteor that gave him his powers. Had he not, he would have certainly died with no one ever remembering him. Instead he became one of the vilest, cruellest villains in the DC Universe, a man responsible for untold murders and multiple wars, and was the first cannibal. All because he was attracted to a bright light...
Ultron started out as Hank Pym just tinkering around in his lab. Flashbacks revealed his original appearance looked about as threatening as WALL-E. Then he rebuilt himself a skull face and glowing red eyes...
In at least one alternate future, Victor Mancha of the Runaways is destined to become Victorious, a dreaded, mass-murdering super-villain who slaughters the Avengers. But in the present, he's pretty much the designated Butt Monkey of his team.
The Runaways' original enemies, The Pride, were all a bunch of nobodies and small-time crooks, until they were summoned by a trio of monstrous descendants of fallen angels who offered them work. Since then they have been a criminal organization that controlled underground activities on the West Coast yet managed to stay undercover in the Marvel Universe for years, were respected by such powerhouses of crime as the Kingpin or the Hellfire Club, and at one point gave the Marvel Illuminati — a group composed of Iron Man, Reed Richards, Black Bolt, Doctor Strange, Charles Xavier and Namor the Sub-Mariner — a run for their money.
Parker Robbins was a loser and small-time crook, until he stolen magic cloak and boots. As The Hood quickly rose in rank of criminal world, until turning into a leader of gang strong enough to butt heads with Avengers and live to tell the tale and gaining himself a place in Cabal.
At one points other supervillains wonder why exactly they follow him and his cousin calls this trope - they all started as nobodies, before becoming superpowered crooks, but they had normal life, while Parker was the only one to start from the bottom and knew what to do to crawl his way to the top.
Transformers: Wings of Honor: Inverted: Before the war, Strika was a security guard assigned to a scientific outpost, at the end of the Autobot-Decepticon war she's one of the Autobot's top Generals and Co-leads the Autobot/Decepticon alliance against the Cybertronian empire.