"Weird" is just a synonym for out of the ordinary (though one often meant as an insult) and being out of the ordinary isn't quite the insult that "normies" (in the sense of "close to the norm") think it is: being a great genius is weird, being a top Olympic athlete is weird, being amongst the most exceptional people in a profession is weird.

Absolutely, the other end of the scale is also deemed weird and one can hardly claim that being, say, way below average intelligence is a good characteristic to have.

The point being that merely being out of the norm isn't by itself a bad thing.