When you start getting into this, you get a lot of comments from people who care a lot about things which, actually, most people do not care about. And they will often paraphrase the thing they are concerned by, rather than quoting it.
There is no perfect Bible translation. There’s not even a perfect original text to work from. What there are, are decent translations.
If it has an Imprimatur then, no matter how scandalised some people get on the internet, it’s been judged by a Catholic bishop as not containing anything contrary to Catholic teaching.
If you want something scholarly, that you will then use as a base text for in-depth study, go with an NRSV-CE. This only describes the translation, not a particular physical book: that will be a further choice for you to make. If you want a Bible that will suit memorising and reciting, and resonate with the texts you are already familiar with from Mass, and be thoroughly Catholic, get the CTS Bible.
You are being further confused because people are describing perfectly valid Catholic positions on the Biblical text as being problematic, and also using this as an excuse to rail against translations that are irrelevant to the UK. There are a variety of valid Catholic positions, as long as they remain within certain bounds, just as there are theological questions to which there are a variety of valid Catholic answers. I don’t think you’d find anything difficult with the CTS notes, and in fact I love the way they talk about how the texts are used in the liturgy.
Don’t get so caught up in finding the ‘perfect’ Bible: get a Bible and start reading it. And ignore people who insist that something with an Imprimatur is obviously heretical and unorthodox in such a way to be unusable. You will find people who say this about everything.