I don’t like dour hymns either, because they just drone on and on.
But I do like the messages in hymns such as “When I Survey the Wonderous Cross” or “Be Thou My Vision” or “Blessed Assurance” or “Amazing Grace”.
I also don’t mind the hymns being blended with a praise song which is what our worship pastor does sometimes.
We do half and half on Sunday morning. On Sunday nights and Wednesday nights—we do traditional hymns. Once a month, on a Saturday night, we have a “contemporary praise service” for those who are inclined.
I, of course, ever conservative still prefer the old hymns.