My first name is Andrew, which no-one calls me if i can help it!
My middle names are Norman - after my dad, and John after my godfather. I was teased all through school about my dad's name, and I never use it.
I vowed that if I had a son, he would not carry Andrew as a middle name - but we had a daughter, so no problem, she is Charlotte Mary, the Mary is after her mum.
My grandson is Jacob John, the John is after his paternal grandfather, and my second middle name, which i think is nice - I don;t think Jacob Andrew works.