My mother had intended to name me after herself - she has an unusual name. I've only known of 1 other with the name. She didn't in the end because she didn't want people to think she was being narcissistic, but I would have loved the name.
In the end she called me Stephanie and I hate it, very rarely use it, and almost everyone knows me as Kia for the past 12 years or so.
My name was used to bully me (not to mentioned that the spelling got butchered by pretty much everyone too) when I was at junior school which really didn't help and when added with my surname which was also used to bully me I came to despise my name.
Grandma thought it was "pretty" and so for all my early life I was called by Stephanie, not a shortened version, and no one ever thought to use my middle name, even though I used to get so upset with my name.
I was really excited to change my surname when I got married. The year leading up to the wedding I got very much into family history and in the end I kept my maiden name as an additional middle name

My middle name is Ellen, after my mom's maternal Grandma who was Rose Ellen.
Mom is happy for me to ditch my name, she's sad that I didn't like what she chose but understands why I don't like it and thinks I should have a name I like.
My dad and Grandma on the other hand are very against my changing my name.
Hubby and I simply couldn't agree on a name we both liked for our late son. We wanted an older name, but not too old, uncommon, but not too unusual. We didn't want his initials to spell anything odd and it had work work with our surname. In the end we picked his name from a keyring stand in the souvenir shop at Cadbury World! He was Oliver Reece.