Michael Tanner on Nietzsche's last year of sanity and Twilight of the Idols:

And this is Nietzsche bravely talking about the joys of heaven from a position in hell--for this last year he says No as never before. One might even say that his affirmations are only, and this is his tragedy, the negations of negations. His faith--and it is remarkable to find him talking of faith at all in a positive way--is that it is possible to be someone who does not need to negate first. But he could never be that person, and the more dialectical cartwheels he turns, with wonderful and entrancing dexterity, the further he is removed from that ideal. The only Dionysus we can identify him with is the one torn into innumerable agonized fragments.

I think this passage does a pretty good job summing up my own misgivings about Nietzsche, while still maintaining the respectful awe I feel towards the writings he left us. And if we accept Tanner's idea that Nietzsche wanted to be someone who didn't need to negate in the first place then we have to think that perhaps Nietzsche's philosophy becomes a relentless and agonizing self-criticism (of the pessimist inside, perhaps) that simply enacts, over and over (the tragic irony!), the problem it seeks to solve. If only philosophy had the power to do away with itself...if only it would perish forever in an instant of joy, of pure Yes-saying, that abolishes all the little no's we say in self-defense against the universe.