You know the definition of charisma is likability. You say you dont want charisma but want to be liked. Those are literally opposites. Its not a curse, its what you are choosing for yourself. No person is born the way they are throughout their lives. We all change on a daily basis. We make small changes in our behaviour to fit in with others, to be liked and cared for. Thats how humans survived until now. You cant expect a person to like you if you refuse the idea of being likable.

You dont have to be whatever you imagine the ‘friend of everyone guy’ to be like (Im saying it like this because that is not an objective description of a person). You can be any other version of kind likable people.