When I was buying in late 2019, I went with the CRV over the RAV4 and Rogue. I did read about CVTs potentially being an issue, but I researched it thoroughly and my concerns were put to rest. I realized previous history and perception of CVTs were a greater issue than actual recent performance of CVT transmissions and that there were very few complaints actually reported about CVT transmissions on CRVs and Rogues in the recent model years leading up to the one I got. I haven't regretted getting the CRV once.
But, I have been very, and I mean VERY, relieved that I didn't get the RAV4. Before you get one, I would strongly suggest seeking out a forum such as this, but for RAV4s. I joined both at the time I was looking to get a better feel for anything I needed to know about the cars, and the number of little issues that I was going to have to problem solve were numerous on the RAV4. And the big problems with the 2019 model were indeed transmission issues. So numerous that owners were pushing for a recall, but Toyota only issued a software fix to correct the issue. It worked for some, but not for all. There were actually owners that were able to file under the Lemon Law to get their money back for their 2019 RAV4s because of their transmission problems. So, make sure you are choosing the year wisely, but also don't just assume that the regular transmission is good to go just because it is a Toyota.
Good luck with whatever your final decision is for your next car.