I think it's all just a matter of taste. There are some old hymns that do nothing for me, and I feel like I'm just mouthing words just to get through them. But then there are modern songs {Shout to the Lord, for example} that are amazing in their ability to put me in the spirit of worship.
I admit there are a few modern songs I like. I like "Shout to the Lord," too. I'm not good with titles, though. And yes, there are some of the old hymns that are incredibly boring. But a huge part of the excitement value of any song is in its arrangement, and there's a tendency to arrange the older hymns with a tiresome piano arrangement.
Bach and Handel and Buxtehude aren't boring, though. Mozart isn't boring; listen to the "Vesperae Solonnes de Confessore" and you will be thrilled. As a Protestant I must admit with regret that some of the most beautiful and holy music was written for the Catholic Church.
There are some great modern praise songs.
Some not so good ones as well.
For me personally, I attend a church that only sings the OT Psalms.
It is different, but I love it more than my old hymn-singing church.
The Psalms are so beautiful. But, that doesn't mean I don't sing a hymn sometimes. :)
Modern worship music is often taken from scripture. The worship in our church was done by the children today and it was amazing. God does NOT fit into our little box. He's about doing what HE wants to do in our churches through the music HE puts on people's hearts. I've been in Catholic churches and they know nothing about harmony from what I can hear. The music doesn't inspire worship from what I've seen and heard. Baptists sing hymns better than almost anyone and spirit-filled churches sing worship songs better than most anyone. And we like hymns, too! Thank God he's not as persnickety as some folks here. God is present in many kinds of music.