My mum doesn't have a middle name and it's scarred her for life! Coupled with the fact that she never liked her name, it was her mum's name and her mum wanted to call her something else, but her father went and filled out the papers while her mother was still in hospital so it was done and dusted. FWIW, if I ever have a daughter I'm giving her my mum's name. It's old and it's gorgeous and there aren't too many around.
DH doesn't have a middle name. Again, scarring. All the first born sons in on his pateral side of the family where given the name W. His mother decided that she wanted to buck tradition and gave him a different name. To add insult to injury to a long line of W's she didn't even give him that name as a second name - she just named him P. He still holds it against his (deceased) mother.
DS1 has two middle names. His first name is N because I had a crush on an N when I was in year 3 at school (he's probably fat, bald and completely ugly now). His second name is for my pop (the man in question for giving my mother her name) and his third name is for my father's grandfather because I thought the name was completely cool but didn't have the guts to give it to DS1 as a first name. I wish I had now because it's a completely awesome name!!
DS2 has one middle name - actually he has my father's name, although there will never be any confusion because all the men on my father's side of the family go by their middle name and not their first name. The first name is the "proper" name and the ones after that are the preferred name that they really wanted to call their sons but didn't because they had to give them the proper one.
Bookmarks