SDG, I think there is a RIGHT way to spark the emotions with music. David didn't write Psalm 51 in an emotional vaccum. You can hear the sorrow and contrition in his words 'against YOU ONLY have I sinned'.

I doubt Psalms like 95 were sung sitting still in ancient Israel. In fact, I personally wonder what kind of person who claims to be saved (specifically if you're reformed) can sing through Cowper's Hymn

"There is a fountain filled with blood
drawn from Immanuel's veins
And sinners plunged beneath that flood
Lose all their guilty stains"

and not have his/her emotions stirred within him with gratitude for the salvation which God has given. Sunday, I saw men and women come to tears as we sung through some modern rendition of one of Cowper's old hymns... and the words were so rich with theological truth, the music so appropriate at the moment that yes, our hearts were stirred, our emotions welled up and some of us came to tears at the singing of words which expressed God's providence and preservation of us and His giving of Himself for His sheep.

*edit*
That being said, I do have problems with music which takes familiar secular melodies and remakes with Christianized lyrics. Sorry, but it's very difficult to get into the right frame of mind for worship and remain there when the music is bringing up stuff probably from where you came from.