He's sort of Batman and Punisher, but Marvel don't seem to know what to do with him. He has a lot of potential, but the biggest problem is that Disney keep screwing this stuff up, and the best Moon Knight would be one far too violent for Disney+.
Initially his character was powered by the Moon God Konshu (after Spectre dies, is resurrected as Konshu's servant and imbued with Konshu's power), and his different personas were disguises (like Batman and Bruce Wayne), but later versions had him have multiple personalities, so he became an unreliable narrator, and you were never sure if the story was actually happening, or if it was a figment of his madness (including his service to Konshu or if Konshu existed at all).