For my three kids, we used a family name for the middle names (my dad's name, my mom's name, and my middle daughter has two middle names: my grandmother and my wife's mother's name). I tend toward the second one you suggested, since it contains your own name as his middle name. I like that my kids will be able to point to something meaningful in their own names. We also tried to name the kids in a way that they could use their middle name as their first if they ended up hating their first names, as well as having a first name that could be shortened to a good solid nickname if they wanted. In the end, I think you should consider the value of a name that'll shock everyone you know versus the fact that your kid will be saddled with that name for a long long time to come, well after the joke has worn off. I do think I'm in the minority when it comes to naming: I prefer more classic names (some would say boring), but I think most people nowadays prefer more creative names. I guess in the end, the name is a reflection of the personality of your family.
Names with history
For my three kids, we used a family name for the middle names (my dad's name, my mom's name, and my middle daughter has two middle names: my grandmother and my wife's mother's name). I tend toward the second one you suggested, since it contains your own name as his middle name. I like that my kids will be able to point to something meaningful in their own names. We also tried to name the kids in a way that they could use their middle name as their first if they ended up hating their first names, as well as having a first name that could be shortened to a good solid nickname if they wanted. In the end, I think you should consider the value of a name that'll shock everyone you know versus the fact that your kid will be saddled with that name for a long long time to come, well after the joke has worn off. I do think I'm in the minority when it comes to naming: I prefer more classic names (some would say boring), but I think most people nowadays prefer more creative names. I guess in the end, the name is a reflection of the personality of your family.