I got my middle name from my mom. Mom and dad couldn't decide on a name (one wanted Peter the other wanted Martin), so I got one as my first name and the other as my middle name. It's just a middle name, though, so I don't use it all that much, and it's not supposed to be hyphenated to my first name in anyway, though teachers throughout the years have had a hard time understanding that.
I don't mind boring names, to be honest. Being called Bob (which is just short for Robert) is, in my opinion, better than Christophpher-Alexxander William Michael Smith III.
I used to know a boy named Wolf Alfonso. What. That name isn't normal in Germany, either. His sisters had ever so slightly more normal names. They were (fallen) royalty, to be fair, but still.
Also had a Friedrich Wilhelm (Frederick William?) and Jan Moritz (we used to call him Jean Maurice) at school. And a few other curious ones.
As for my middle names, it's my mum's name, then my maternal grandmother's name, then my paternal grandmother's. My parents fought over it a lot and this was their compromise.
This is also much easier to explain in Urdu as there are actual words for most family relations (ammi, naani, daadi in this case). Everyone should speak basic Urdu, Urdish is the most efficient language ever!