My reply to the question used in this thread's title (with thanks to "Bill" Shakespeare): A lot is in a name . . . and a lot isn't. In other words, while first impressions are important, people can determine how others will perceive them via their conduct, and a name that might seem awkward, unattractive or even heinous can be neutralized, or even made attractive, if the owner of that name is a decent person.
On the other hand, parents often give a child a name out of their own questionable sense of humor, or for reasons of ego, or due to family pressures, or whatever. But they don't think of the child, and what effect this will have on the child. And that, to me, is Consideration #1.
P.S. As for a bizarre name giving a person character, as is considered via the "Boy Named Sue" song . . . you'll note that at the end of that song, when the father informs his son the difficult name has made him stronger--a real man--so isn't he glad he was given that name . . . the otherwise forebearing narrator replies with a resounding "NO!" ;^)