Dr. Michael Hfuhruhurr and his true love, Miss Anne Uumellmahaye, from Steve Martin’s deliriously silly (“Get that cat out of here!”) The Man With Two Brains.
Smitty Werbermanjensen, Mr. Krabs’s quickly-thought-up fake name for the owner of a precious hat in SpongeBob SquarePants.
I’ve got quite a few, many of which were already mentioned:
Zaphod Beeblebrox
Hotblack Desiato (particularly because of its origin)
Ragnar Danneskjold
Francisco Domingo Carlos Andres Sebastian d’Anconia
Galadriel
Severus Snape
Sirius Black
Scorpius Malfoy (Draco’s son)
Indiana Jones
Father Jack Hackett (“Feck! Arse! Girls!”)
Willy Wonka
A couple from World of Warcraft:
Borean Marmot (this is a critter, but I always thought it would be a great name for a British explorer: Sir Borean Marmot)
Natalie Tootieblare, a gnome in the Dalaran Underbelly
Not quite characters in the sense of the OP, but the names the ships chose for themselves in Iain M. Banks’ Culture novels are pretty cool. They would pick names for themselves that reflected both their personality as well as their purpose.
Favorite from the series is the ROU(rapid offensive unit) Frank Exchange of Views. Delightful! Heres a wiki with all the rest.
Then of course there is…
Fred Farkle.
His wife, Fanny Farkle.
His daughter, Flicker Farkle.
The twins, Simon and Gar Farkle.
The baby, Sparkle Farkle.
(from Rowan & Martin’s Laugh-In)
About 1987, Spy magazine ran a piece on what I can only call guerrilla junk mail. It involved signing up for mailing lists under outlandishly absurd names:
Oovus Oozfuz
Prof. Drano Lummox
Bunni D’Hottub (job title: Producer’s Girlfriend)
Whip Blah, Jr. (of the National Endowment for the Inhumanities)
Guy Inagorillasuit
and my personal favorite, Rasputin Pianothrower
One purpose of the piece was to see how rapidly the names propagated through marketers buying or sharing each other’s lists. And they did propagate rapidly, absurd though they were.
Oh dammit! I was getting to the end of the thread, all excited because no one had chosen those yet.
And don’t forget Melanie Haber, Audrey Farber, and Betty Jo Bialowsky.
I’ve never seen a Sherlock Holmes movie or read a story, but I always liked the name. It’s also become part of the cultural landscape (“No shit, Sherlock”).
This is low-brow, but I love the name of Jason Statham’s Crank character: Chev Chelios.
Atticus Finch
Animal Mother (from Full Metal Jacket)
Speaking of Kubrick (or rather, Peter George, who wrote the book): Dr. Strangelove, President Merkin Muffley, Gen. ‘Buck’ Turgidson, Col. ‘Bat’ Guano, Maj. T.J. ‘King’ Kong, Lt. Lothar Zogg
A few (more) from Peter Sellers, who had tons of great character names:
Chauncey Gardener (aka Chance the Gardener)
Clare Quilty
Dr. Fritz Fassbender
Insp. Jacques Clouseau
Hrundi V. Bakshi
Pearly Gates
Federico Fabrizi
Hector Dimwiddle
Fu “Fred” Manchu
Dick Scratcher
Henry Orient
Auguste Topaze
Dodger Lane
Crystal Jollibottom
Sir Jervis Fruit