I think it is all about intent. My friends calling me weird isn't a problem, but when a person rolls their eyes and scoffs "...weird" then yeah, it is insulting. Having been called weird many times in my life, I can at least anecdotally say that the effect varies on the situation.