At my little mission, we primarily use the psalter in the translation of Archimandrite Lazarus (Moore). It is dignified, contemporary English and avoids Ye Olde Worlde Englyshe of many translations. The text can be viewed, (with translation notes) here
] and can be purchased here
As we produce our own liturgical booklets for our use, we don't encounter the problem of mismatched translations.
The only problem is that Fr Lazarus did not include the Old Testament canticles in his psalter. So I'm having to look to an alternative source for these. I have recently ordered and am awaiting the arrival of this psalter
], as I'm told that the translation of the canticles is actually fairly decent. I look forward to its arrival so that I can complete the booklets for the psalms and canticles at Vespers & Lauds throughout the week.