Out here, professionally it's a no-no. Although I know people who use such terms across the board, and I think, there are worse, and some cultures use really unflattering terms (not meaning so). Also out here sir and ma'am usually infer 'old age', so seniors will even say "Don't call me that, that's my father".
I will say this, as a person who tries to remain professional but is in tune and heart is in it, and sees everyone individually and with respect: when I'm going from person-to-person-to-person, and have other "person's " needs also on my mind, (and am exhausted, always), sometimes I draw a blank on a name (though I'm attune and remembering most or all of the person's other, even smallest details). And the person can't become aware of others' names, so best to not use any.
FWIW, when I AM guilty of using a term like sweetie, I really mean it, and often can't help it, it slips out. And through my eyes it's because I really see them as wonderful, sweet, strong, brave and amazing. And I respect them a lot. (If I know I'm likely to slip, I try to interject 'dear'(X)' in front, because it is true.
For myself, if it's not rote, I don't care what people want to call me, they usually screw up my name, anyway. Even then I say, 'hmmmm.. Angela.. Veronica... kind of getting used to them now, haha ' :laugh:. I've had cruel interactions, and gone through a lot of verbal abuse, so if someone seems genuine, and kind, I actually think it's a vote of confidence in me, or inclination of them to be kind/ on my side. Especially in a medical environment (which I wholly avoid, and am vulnerable and triggered and feel wholly unsafe) I would say invested in me, just as a 'human', even. Not an impersonal number or dollar figure.
JMHE though.