Some of it can depend on the hymn. For example, the hymn Come Ye Sinners has a wonderful tune that, ironically, sounds a bit depressing thus, at one church I went to, the assistant pastor set it to a more joyful tune. Similarly, "Arise My Soul Arise"'s traditional melody is a bit mellow for the powerful words.
On the other hand, I have been absolutely disappointed with a modern rendition of "For All the Saints" because the old Ralph Vaughan Williams tune captured the message of the hymn so well (and, in my book, ranks with "A Mighty Fortress" as one of the great hymn/tune combinations of all time) that the mellow modern tune seemed disconsonant and not fitting for the powerful lyrics.
Again, it depends on the hymn.
On the other hand, I have been absolutely disappointed with a modern rendition of "For All the Saints" because the old Ralph Vaughan Williams tune captured the message of the hymn so well (and, in my book, ranks with "A Mighty Fortress" as one of the great hymn/tune combinations of all time) that the mellow modern tune seemed disconsonant and not fitting for the powerful lyrics.
Again, it depends on the hymn.