There is an old book that delves into these Archetypes called "King Warrior Magician Lover". You might enjoy the read....
I loved this article... This writer is awesome. Like, he's better at being me than I am. I'm a little worried he might be in the covid cult, but that's a minor point, considering.
https://www.lesswrong.com/posts/Wg6ptgi2DupFuAnXG/orienting-toward-wizard-power
Discussion
Heard of it. Still haven't read it, though. I'll stick it in a cart for when I'm ready for more books