I really appreciate the way you've articulated your thoughts on this. It helped me reflect once again on the way Nietzsche affected me when I first read him.

I was about 20 years old, and had lost several important friends while also briefly dropping out of college. Saw Nietzsche on a bookshelf while making an effort to continue my education independently as I saved money. I was young enough to earnestly jump into pursuing "the whole damn truth," and my mental health be damned. Cue years of unrelenting depressiveness, self-absorption, solipsism, fragile and tragic romantic relationships, etc.

I completely agree, and I think a lot of people who don't "get" Nietzsche are actually reacting to his ideas perfectly rationally with respect to their (not necessarily anti-intellectual) values in life. I for one would have been much more fortunate to have studied him in an academic setting, with a group of peers. I recall reading once that Nietzsche's ideas are valuable insofar as one finds a resistance to them.