Does Music Really Transcend Boundaries?

I just finished a basic harmonic analysis of Beethoven's Mass in C, and to take a break before I listened to some other master works, I thought I would listen to Gesang der Parzen.  Again.

I opened a book that accompanies some of the major works I listen to.  In the introduction to Brahms' shorter pieces, there is a little blurp about Triumphlied.  The author briefly comments on how many people have disapproved of this piece because of the impetus for the composition- which was a celebration of a German victory in the Franco-Prussian War (which I know very little about.  Next to nothing, actually- all I know is it is the beginning of Germany as a country instead of provinces).  It was dedicated to William I, the first emperor of Germany.  It is interesting to me that this author, who was a bit older when he wrote the book, still observed people disapproving of something like that.  When I hear the song and learn of it's history, I don't think about not enjoying the piece because of the inspiration.  I take it as a part of history.  I wonder if, in years from now, the stings of our current history will fade and music will become music, history will be history, and interactions and opinions will become a part of the music and history fold.  Did people really prevent themselves from enjoying a piece because of their condemnation of history?  In the same way I will listen to and enjoy Carmina Burana despite the fact Orff worked the Nazi system to his advantage (he hid the fact his grandmother was Jewish and then seemed like a passive supporter of the regime until the end of WWII).  Does music always transcend boundaries?  Let's say that a composer wrote a piece of music that included text offensive to many listeners, but the music was beautiful, interesting and the text cleverly set.  Would people find the merit in the music?

I think in this case, yes.  Music transcends boundaries.  But I have never heard a cleverly and musically set piece that I disapproved of the lyrics.  And I suppose there could be issues that would just be too personal to me to enjoy.  I'm so glad composers write music for the greater good and rarely try to harm humanity by composing destructive pieces.