I like my middle name - Michael. Nobody else in my family has it, except for my son (his middle name, too).
BTW, he was not "named after me," he and I have the same middle name purely by coincidence. My wife and I both thought that it sounded good with the first name we chose for him, but I didn't want to name him after anybody. After two months (this was before he was born), I finally relented and gave in, but only on the condition that he has that middle name only because it sounds good with his first name, and not because he was named after me.