When I first read your question, I thought you were asking about dog and cat names! Just about any name can be either endearing or insulting, depending on the source, context, and intent. I’ve been called a huge array of things, by people who cared about me and were using the terms affectionately, which is fine. I’ve also had the experience of being called “sweetie” or “dear” in a dismissive, demeaning way, and I wished I could have hauled-off and smacked the speaker.