The difference betwene listeing to musical cd’s and chazzanus in shul is that in shul, I am a captive audience, bound by the chazzan’s desire to lengthen davening. When I’m listening to moving niggunim on cd, I choose the time and place. Chazzanus is nice, but not on my cheshbon. Sometimes the cynical part of me says the chazzanus is a way to give everyone a chance to catch up on the latest news.
Chazzanus can be moving. I recall my old mussaf chazzan, who would literally and sincerely be crying by mi yichyeh mi yamus, and yes it brought home the moment. Listening to a chazzan repeat “uvyom” 8 times before saying the word “haShabbos” does not do it for me. There really is nothing to debate here. Chazzanus is like petcha- a nice delicacy for those who appreciate it, but a bit revolting for those of us who haven’t “acquired” the taste. One chazzan told me that chazzanus was more popular in Europe, when their seudos Shabbos were much more spartan, and the chazzan was the weekly entertainment. Times have changed. Enjoy your chazzanus, enjoy your petcha. But please don’t force either of them down my throat.