Is Joseph Campbell at all interesting to anyone who already has solid basic knowledge of mythology? From what I can tell he seems like a glorified self-help author.
Joseph Campbell is fucking great. I have no idea where you got that impression from. Check out The Power of Myth available as text or as a video series. A series of interviews he did with Bill Moyers for a general introduction to his thought.
His Masks of God series is also fascinating.