The Shivans from Freespace. Not only were they named after Shiva, the Hindu God of Destruction, but they were also dubbed as "The Destroyers" by the Ancients.
The final boss of the storyline in Borderlands is named the Destroyer. Amusingly, the mission where you fight it is named "Destroy The Destroyer".
The overarching threat in the Eye of the North expansion in Guild Wars is a race known as the Destroyers. Their boss is, fittingly, known as The Great Destroyer.
The Star Destroyers most likely draw their name from Destroyers, a type of warship which in modern navies is smaller than a Cruiser and bigger than a Frigate. Originally, the name referred to their role as Torpedo Boat Destroyers, with the ships being designed to screen battleships and cruisers from swarms of torpedo boats. As naval warfare evolved, so did the Destroyers, with their roles gradually shifting to focus on anti-submarinenote Submarines are essentially torpedo boats that hide under the water or Anti-Airnote Anti-shipping aircraft essentially filled the same niche as torpedo boats, only much faster and in the air. Modern destroyers, armed with dozens of guided missiles giving them a reach and punch equal to any other warship on the battlefield, are essentially modern day Battleships, being distinguished from modern cruisers only in tonnage rather than role.
The GCU Grey Area - AKA Meatfucker - from Iain M. Banks's The Culture. A sentient spaceship that kills aging despots by making them die repeatedly while they sleep. He also reads your mind, and contains a museum of torture. He doesn't get many visitors...
In Western Animation/MAD , one of the sketches focuses on a lawyer who successfully convinced a jury that "Rob Killmurder" was an innocent man and he goes free but not before punching the lawyer in the face and running away, laughing crazily all the while.
In the Tales from the Crypt story "Clots My Line," a game show panel is asked to guess the profession of a contestant named "Pierce Draynor." Subverted, as the contestant is Actually Not a Vampire; rather, the host is having fun with the panel and the audience, who are.
Or any use of the name, really. The Harkonnen Devastator from the Dune games is the biggest, baddest tank around. In Duke Nukem 3D, Devastator is the local BFG. In World War II, the Douglass Devastator was a torpedo bomber used by the Americans early in the war, before it was replaced by the Grumman Avenger.
Decepticons in general. You'd at least figure the world would realize you can't trust one. It's not 'til 25 years after their debut when, in Transformers Animated, someone actually brings up the name thing. (Jazz: "Deceived by a Decepticon. Who knew?")
Tod Slaughter, known for his roles in film adaptations of Victorian horror melodramas and is particularly known for his portrayal of the original Sweeney Todd from the penny-dreadful "The String of Pearls".
Former Cleveland Browns wide receiver Webster Slaughter.
Baseball Hall of Famer Enos Slaughter, particularly if you were a pitcher in the 1940s.
Ugly Americans: almost all the demons have an intimidating name, but Twayne Boneraper takes the cake. Subverted because he is scary just in the first couple or so of episodes, then he is flanderized into a whiny, clueless, neurotic momma's boy.
Louis the Pious had three sons, Pepin II, Charles the Bald, and Lothair. Guess which one tried to take over the Holy Roman Empire...
Apparently, a man in Britain named Rob Banks was accused of bank robbery. The court subsequently granted him the right to be tried under a pseudonym on the grounds that his name might, in fact, influence the jury.
One of the infamous nicknames given to Vlad Dracula: "Vlad III The Impaler."