I really like when middle names have a special meaning. I feel like that gives purpose to a middle name (and I don't mind the idea of no middle name either). Whether it be the parent's middle name, a family name, a significant place, etc. I don't personally understand giving a middle name just for the sound of it, or because it is another name the parent likes- that is for the first name IMO.
Obviously JMO, and people can name their kids whatever they damn well please :)