I loathed my one sylable, very over used, name. To make matters worse, my surname was only one sylable, and also had a very dull middle name. My Mother regretted not calling me the unusual family name she loved, when she realised how many others with my name were in my class - especially at senior school which was all girls school. I was so envious of my 3 best friends, Susannah, Jessica and Elisabeth, with the different options for nn's they all had.
Now, DH's best friends wife has my name, one of my best friends has my name, my other best friend has my middle name, and I am always running into others. It gets confusing at toddler groups etc... When we used to this area, I seriously considered changing my name to the name my parents had wanted to call me, but not been brave enough. DH and parents were supportive (it was actually my mums idea). I decided in the end that I actually like my name, just not how many others have it, and as my married surname is long, at least my whole name together isn't really dull anymore. I thought it would be a bit pretentious to change it completely now, when my name is just dull, not ugly.
Needless to say, my daughters have unusual names! And they are long, with multiple options for nn's. They have a much more normal middle name each, so that they can switch to that in the future if they so choose. My son has a more normal name, as important family name for my DH, but its a long one with lots of options for nn's.
I'm sure this is partly down to the kind of personality you have. So far my 6 year old loves her unusual name, and was most put-out when she discovered another one , even though it was only in her French textbook at school!