if you like the ESV, you should like the RSV. I have a Catholic edition of the RSV but it isn't a study Bible. I think Ignatius has a RSV study Bible and I have been wanting to get that.
I myself use the Orthodox Study Bible as my personal bible. Though there are footnotes which are objectionable to Catholics, overall it is a good translation with lots of comments from the Church Fathers and it is usually approved for Catholic use (my priest said it was okay for me to use it).
You might see references to the NAB and to the NABRE. A few years ago they revised the NAB, so if you go to a bookstore and look for the NAB, you will only be able to get the Revised Edition, which is fine. The NAB(RE) has extensive notes, and it is all approved by the Church.