Like anything else, depends how it is used and how it looks. Games like genshin impact and granblue fantasy versus barely look cgi/3d. You can tell it's cgi, but it'll be easy to forget it's cgi.
But then you have cgi that's just very obvious. I notice it mostly with anything vehicle or mech based. The drill in avatar the last Airbender, space ships, cars, etc. Often times these things are so noticeable against the 2d environment that it takes you out of what you're watching. It's better today, the cgi mechs were less glaring in legend of korra as an example. But it can be difficult to make them "blend".
I think we are at the point we can make cgi look like anything we want. Puss in boots the last wish barely felt cgi with its painterly style, textures, lower fps, and 2d backgrounds. We don't need everything to look like disney/Pixar. I think it would be neat to see an anime in the classic anime/etc style that is fully 3d/cgi. Beastars is an interesting anime and style but it doesn't "feel" anime. It feels much more "western" in vibes, style, etc so I have trouble counting it.