I'll just say that at no time during The Force Awakens did I notice any CGI and have it take me out of the moment. As far as I'm concerned, a ship crashed in the desert, and later it sank into the sand. I had no idea that the sinking into the sand was all CGI.
Things like the fight on board the Millenium Falcon with the aliens trying to catch and eat the humans, that's obviously CGI, but I was engrossed in the story and it didn't bother me at all. As far as I'm concerned, they were being chased through the ship by aliens. It looked great. I didn't think "Oh this is so bad, so obviously fake."
So I guess what I'm saying is that yeah, CGI is only noticeable when it's bad and/or takes you out of the moment.