Please suggest me some good personality development books, podcasts or anything as starters so that I can finally attract people.

I am tired of being called out and getting rejected countless time for being "too genuine, innocent and boring". Since I am not physically good looking either I just need to become an attractive person by improving my personality. My people pleasing attitude sucks and not knowing how to be mysterious, charming, dominant and not knowing how to play mental games makes me such a low value guy. Nowadays I feel so ugly about myself that I even hesitate to enter elevators if there is just a girl inside. I don't personally feel like my communication skills in general is bad and I usually talk about a variety of topics. It's just that I don't know how to approach anyone or make them interested to be in a conversation unless they're interested me due to the first impression which I give.