Used judiciously and appropriately, CGI isn't a liability at all. While not perfect, the LOTR films found a reasonable balance. Problem is, CGI has become an avenue for lazy film making -- with directors opting for CGI when miniatures or physical sets would provide better results (see the hallway sequence in Inception
for an example of how to realize fantastic visuals without the crutch of CGI) . Nolan's Batman films have done a laudable job of appropriately using CGI.