Today at the bookstore, I decided to buy the first book in a paranormal mystery series by an author I hadn't read before. All was well until I came to a paragraph in which the narrator talked about people coming from the mountains of Wisconsin. Since the mountains of Wisconsin are as well known as the flatlands of Tibet (as Eugene put it), I was a bit taken aback. I didn't hurl the book across the room, but it did count as a serious strike against the author in my mind.
Something else that struck me was the introduction of a secondary character named Sandra. Since my name isn't all that common these days (and it's used more often as "Sandy," which I've never liked as a nickname), that certainly caught my attention. But although this character was friendly toward the narrator/protagonist, the narrator didn't like her too much. (This story is set in San Francisco. The narrator, a witch, thought Sandra, who owns a shop catering to tourists looking for the 60's San Francisco experience, didn't take the supernatural seriously enough.) Perhaps I'm too sensitive to this, but every time I read about a character named Sandra, she's never portrayed as a positive character. I wonder if people just have bad connotations about the name. Perhaps the name "Sandra" doesn't sound as friendly as "Sandy" does, though I feel it fits me better.
I'm not sure there's a writing lesson to this. Unless you're making up names (and thereby losing the power of association), you will use a name a potential reader might have. People with common names might be used to seeing them in stories, so perhaps it wouldn't bother them to see someone with their name as an antagonist or even villain. For someone with a rare name, it might be a different story. There may be many types of Michaels, but only a couple Quincys.
Have you read about a character with your name? If so, did you like how this character came across, and did it make a difference to you as you read?