Re: Middle names.
My brothers and I all use our middle names; I've been told it's a southern thing. Both my folks are from Alabama, and my brothers grew up there. Not me, though; I'm Vriginian, but I suppose the habit followed along.
As for odd names, it doesn't have to be fantasy to be odd. My full name is Edward Austin Middleton. Edward and Austin are both family names, named after Edward Middleton the immigrant gardener who became master of
this; Austin is the maiden name of my mother's great aunt.
What comes up in conversation is the middle brother whose name is Henry Hueston Middleton. Pronounced the same as "Houston". The prepared answer, "no" comes quickly on the heels of, "Are you from Texas?" Hueston also happens to be a maiden name from the distaff side.
It was perhaps unfortunate that Hueston tried to get me to like the Cowboys instead of the Redskins when I was 6; he suggested we name the dog Dallas.
Just to keep the gag going, I figure I'll name the next dog Corpus. Good name to shout when he runs away, eh?
---
ANYway, as far as fantasy names are concerned: name your pets funky things, not your children; you can always get new pets.