Somewhere this week, and I can't remember where, I found a blogger who was requesting good sources for learning classic hymns that were "modern" in their style, yet retained their musical integrity. 

My husband and I love the hymns, and are always looking for really good CDs.  Our absolute favorite is the Passion band's Hymns for Worship CD.  We also enjoy Fernando Ortega's beautiful accompaniments to many wonderful hymns on his CDs.  He even has an older album out that is entirely composed of hymns, although we don't own it yet.  If you're into a more country/bluegrassy style, Buddy Green has an excellent album of Hymns and Prayer Songs on his website that my boys just love.  I'm sure there are more artists out there that have good hymns with their original melodies but updated accompaniment, but these are the ones I have and love.  Now, if I can just remember the nice bloggy lady who posted about this, I can point her to my post.