When it's done to me, it's the magic spell of "I Distrust You". A time or two is fine, as is its usage if one is -say- in a group conversation where it can be difficult to understand to whom one is speaking, or -say- one needs to get my attention when I'm focusing on something else.
In my many years of personal experience, I've found that people who behave as if speaking my name to me is a magic spell absolutely do not have my best interests at heart. At best, they want to manipulate me into doing something that I don't wish to do. I recognize that my opinion is not universal, but I am absolutely not the only person on earth who's like this.
Seems the message got distorted from "remembering people's names shows you care about them" to "use people's names unnecessarily or in bad faith". I was pretty upset by that Apple Intelligence ad where Bella Ramsey pulls up someone's name and then pretends she remembered it – yuck.