Tough luck man. Have been in this situation a couple times.
Current working theory is that the reason are our relationship templates formed in childhood.
If someone has had abusive and/or gaslighting role models early on, they will not avert or even seek narcissistic relationships. I have been in this situation for a long time and am working for years to get rid of it.
This is what I think happens with people liking clear cut narcissists like musk and having friends who „somehow“ like him.