I never thought it would enter into my appreciation either, until we moved from a church that had fabulous music - both choral and contemporary.
Now, in my new surroundings, I find myself very irritated at the fact that the responses are never spoken aloud by the congregation--just murmurs--and the singing is about the level of humming. Grates on me, it does.
I now sing whatever is indicated and simply listen to the grand choral arrangements of old hymns here at home. I have no explanation for why the Church has lost its way on music...and if you ask me, most of them have, whether Catholic or Protestant.
The last church service that had appropriate music (that I heard) was the 2001 service after 9/11 in the National Cathedral. And Laura Bush, no minister she, chose the music.