If you want a good case study in the character of sexual four, one of the better historic examples is Charlie Chaplin, the Robinson biography is particularly interesting and dense: https://www.amazon.com/Chaplin-His-Life-David-Robinson/dp/0141977507/ref=sr_1_2?crid=39QTIVPR0987D&dchild=1&keywords=charlie+chaplin+biography&qid=1603084131&sprefix=charlie+chaplin+biogra%2Caps%2C207&sr=8-2