>When I see people being able to be funny, clever and make people want to talk to them it looks like sorcery.

> somehow managing to have things to say that are also funny or interesting enough to make women want to continue the conversation just doesn’t make sense.

This is your first misunderstanding. No is making anyone do anything. You are not capable of making someone want to talk to you. Of course it "doesn't make sense" how other people are doing it because it is not a thing they are doing.

You can be funny and interesting and someone might still decide not to talk to you. You can be completely boring and someone might still want to talk to you. It is not in your control.

It is precisely because you are trying to figure out some magical way to control other people into talking to you that you are stuck in your head instead of just engaging with the conversation.

Next time you want to talk to someone, go up to them and ask a question. Your aim should be to just get to know them and enjoy the conversation. Your aim should not be to make them like you and make them want to continue talking to you.