If you're really wanting to evaluate the impact/benefits of CGI en toto, watch that first video. I think it points to there being some things CGI is really good for--cost effective and invisible--and things it is bad for.
I think it's about figuring out where that uncanny valley is. Re-watching LOTR, pretty much anything to do with people and people's movement is really hard to get right. Like the shots of them crossing the bridge at Moria were composited live-action shots syncing cameras between the miniature set and the live actors. But lots of Legolas' CGI action sequences are comically bad.
But let's keep in mind that a lot of great classics, like The Mummy (Fraser) and T2 and The Abyss all were made with primitive CGI and still look fantastic, so it really is about approach.
There is also a new thing that directors have to worry about--whether their carefully planned, all-day-setup-single-take practical effect will be dismissed as CGI. There are practical stunts that are not worth doing anymore because people will assume it's CGI.
But, all in all, between the bad CGI and the oppressive color grading, this most recent era of movies is not going to age well at all.