Most modern and not so modern Catholic scholars prefer the RSV-CE and/or RSV2CE.
I like them both.
Most cradle Catholics will prefer the Douay Rheims translation, think King James but Catholic :).
The United States Conference of Catholic Bishops (USCCB) sponsor and profit from the New American Bible, think a Catholic NIV/HCSB.
Some theologians use the NRSV-Catholic edition, it bleeds inclusive language.
Then you have the Jerusalem Bible and the New Jerusalem Bible. The Jerusalem Bible is more orthodox and formal in its translation than the New.
Here’s a list of newer (1983) translations approved by the USCCB:
It doesn’t mean that other translations are not approved (Like RSV, Jerusalem, DR, etc).
I’m finding myself using the NABRE a lot because my whole family (Wife, 3 teenagers and an 8 yo) is in the process of becoming Catholic and they are used to the NIV. I also use the NABRE for my CRHP formation and continuation meetings. Plus they use the NABRE at Mass.
I like the RSV because there are some really good resources out there (Strong’s, the Navarre Study Bible series, The new Catholic Study Bible New Testament, etc).
As long as you are reading the Bible, you should be fine :).