I'm pretty sure I've written before about the difficulty in finding good Psalm settings for Mass. At my place of employment, they must be only the one approved translation (I know I've had discussions about this before with different ones of you who read this; I do not consider myself an expert, I only do what I'm told unless I have reasons to dispute it!)
I have had varying success occasionally using settings from another church in the city, but I have received complaints that some of them are "too contemporary/modern" sounding. (I wish people knew how to describe music better! I suspect they complain more when I do the exact same setting on the keyboard rather than the organ!) The settings are also somewhat difficult to teach someone to sing who doesn't read music, since all the verses are a little different, so I usually just sing them.
One solution I regularly use is the Psalms in "Respond and Acclaim" by OCP. While they are accused of being boring or not having a melody that "goes anywhere," how much can you really do with an 8-word sentence (also that you hope the congregation can remember how to sing after only hearing once--brevity IS the key here!)
But my main complaint with these settings is what seems to me an excessive use of the minor mode "Taste and see the goodness of the Lord...boo hoo hoo..." so for the past couple weeks I have been simply playing the minor mode ones in major, and they sound great! There is usually an interesting modal cross-over thingy that actually can sound really cool depending on how I sharp the 7th, and is what makes the setting listen-able!