My worst character name was a halfling thief called Lotto Rumblebottom. Mercifully he was killed by an orc or something early in the adventure.
Another character was a gnome illusionist/thief named Snorri Agatefinder. The last name elicited some snickers.
For some games I actually encourage quirky, half-serious names. For my Boot Hill game way back when, the campaign featured such characters as Jasper and Ruby Garnet, Sandy and Clay Lomes, Iron Hat (an Indian who wore an old Spanish morion), Peyote Pete, and Ignatius William Lynch, Justice of the Peace ("Judge I. Will Lynch"). The campaign was inspired by Pete Dexter's Deadwood and Larry McMurtry's Anything for Billy, so the whole thing was pretty tongue-in-cheek.