A California realtor named Lake Trout was happy with his name. It proved a very useful icebreaker with clients. The interviewer hadn't gotten an opinion from his brother Brook, though...

A teenage girl surnamed Hooker poured out her anguish to Ann Landers's advice column, and a lady wrote in sympathy, how she as a girl had complained bitterly to her mother about being called Hoar. "My mother told me, 'One day you will meet some nice man, and all this will be behind you.' My mother was right. On [date, some fifteen years past] I married Elmer Tramp." The newspaper editor headlined the column, "That's Why the Lady is a Tramp."

Mary Christmas (Mrs.) lives down the road. There was an embezzler named Stupich on Vancouver Island. Mom knew a Dudley Doowho (spelling? I never saw it written).

Then there are artists who legally change their names (Anna Banana, Joe Average).
The writer Spider Robinson's grown daughter announced to her parents that she wanted to change her given name. "I didn't have a leg to stand on," said Spider. (Fortunately she didn't choose anything bizarre.)