One of Irvin D. Yalom's most acclaimed works is a novel called "When Nietzsche Wept". Apart from being an introduction to the history of philosophy, this book portrays a human and vulnerable side of Nietzsche, albeit in a fictional realm. I would suggest giving this book a try before reaching any verdict. It could build a bridge between your present understanding of him and his worldview- which might be at this moment not so easily accessible, but nonetheless worth meditating upon.