I’ve got both and there is no doubt the RSVCE pales against the ESV because the ESV is so much newer. It is a better translation. Read both versions side by side, few would say the RSV is more impressive after this exercise.
However, all this makes me wish is that the ESV had been produced by Catholics because it contains a lot of evangelical Protestant bias. It remains a Protestant bible.
Let’s get this right, you’re Catholic and you might chose a Protestant Bible??? This is not right. Do you think faithful Catholics when the Donatists or the Montanists were about would even think about getting a bible produced by heretics and schismatics. Of course not.
I think the choice of which bible to choose is quite easy for an American Catholic: the NAB.
It’s used in the U.S. Church in the liturgy, it’s a beautiful scholarly theologically outstanding bible. Sorry guys, its notes aren’t ‘heretical’ they reflect modern biblical scholarship in the academic world. It’s intellectual, it’s not fundamentalist, it’s not heretical.
It is the version of the bible published on the official Vatican website:
vatican.va/archive/index.htm
Why chose anything else, go with the U.S. Bishops and the Vatican. The choice is easy.
I recommend the New Catholic Answer Bible as it has fantastic Apologetics inserts and you can take it around with you for Apologetics/evangelistic work. I use the St. Joseph Edition with Giant Print for my main reading at home.