For me it depends on the delivery.

It sure is depressing when I must listen to the old standards sung traditionally. However, the same songs sung in a modern more upbeat manner can be quite cheerful to me. My most favourite Holiday tunes are those from the Boney M (now a classic) Christmas album.

On another note, I am not Christian, yet I still enjoy the carols.