Either love or hate, and no in between? Not exactly, for me.
I hate it, yet I feel a loyalty to it. I hate the way it sounds. I really hate the AG sound. Yet I feel a strange loyalty to it because it was my paternal grandmother's name, and so I really like to see other people say that they like or love it.
When I was pregnant with my son, my mother-in-law and I were discussing potential names for a girl. We were discussing using a middle name to honor a family member. She asked me what my grandmother's name was, and when I said, "Agnes", she exclaimed, "Ohh, nooo" in a horrified tone. And I was offended. Even though I don't like the name myself. It was kind of along the lines of criticizing a family member yourself but then being offended if an outsider does. I wished I liked the name because I hate to agree with my mother-in-law on anything. I wish I had been able to say, "Well, I think it's a beautiful name, and I'm going to use it!"
Anyway, yeah, I hate it, but I feel loyal to it, and I like it when others like it. But if it weren't for the family connection, I'm sure I'd just hate it.