Actually, the RSV-CE (Catholic Edition) is excellent. The general consensus among orthodox Catholic Scripture scholars is that it is the best translation out there in more-or-less Modern English. The motivation for its publication over 100 years ago was to “clean up” the many errors in the KJV. To this end, it was quite successful. The Catholic Edition (available from Ignatius Press and Sceptre Press - are they still around, haven’t seen them for a few years?), goes a step further and edits some of the more problematic uses of “elder” for “priest” and the like. But, if you’re looking for a translation that has the accuracy and gravitas of the Douay with the readability of a more modern English style, this is the Bible for you.
I second that recommendation. I’ve had my RSV since I was 12.