Some thoughts. There's many a great artist who was weird and had a strange and maybe unpleasant personal life - we still admire and treasure their art. Another is that Jung himself stated that he was driven, and admitted that as a result he hurt others - so do all folks who choose to, or who are forced to follow their star regardless of those around them. This is obviously so with great political and religious leaders, as well as great scientists and doctors.
Jung was definitely a weirdo, maybe out of the same mould as the poet, artist and mystic William Blake. His work sits on the boundaries between psychology, religion / mysticism, and philosophy. As such it is fascinating and there is little quite like it that is so readily accessible to lay folks who are willing to put some effort in. I think it's important to understand that reading his work today is increasingly an archeological experience though - he was one of the pioneers, establishing the foundations of psychiatry from almost nothing. He was one of the first medical men to alleviate the suffering of folks with deep psychosis and he did this by being willing to enter their world of strange symbols with them. But his writings are 60 - 120 years old, and of course are in some respects as outdated as, say, text books on astronomy that old. Nonetheless, for me his most profound insights are bound up with his exploration of unconscious mystical and religious symbols which to him seem to lie at the heart of the human psyche. What Jung attempted to do was to express and explore these in themselves as a natural phenomenon rather than as bound up with actual religious frameworks. He found that this concept was too subtle for many, who mistakenly thought he was treading outside the boundaries of psychological theory and trespassing on religious ground. Mind you, I do wonder if he did end up doing just that ......
He must have been a real nightmare sometimes as a family man, but as often happens with men who have the charisma of greatness he won undying loyalty from his long-suffering wife Emma. She was a genuine hero who helped stabilise the foundations of her husband's clinical and teaching work. It's well worth reading Caterine Clay's biography of Emma, called Labyrinths.
As an aside, I'm personally very strongly opposed to the idea that someone's work should be discredited because of perceived or actual faults in their private life and history. I think that Jung was the sort of person who could come into your life, use you, then move on without looking back when he didn't need you any more. He confessed to this in the footnote to his autobiography. For me that doesn't alter the extraordinary journey of mind-stretching insights that anyone can have by exploring his work, and that of his disciples.