CGI is just another tool for creating special effects. I'm not against the use of CGI. I'm against lazy film making; throwing CGI at the screen in order to make a quick buck.
One of the reasons that effect heavy movies like Justice League look so bad, is because apart from the effects, there is not much else there to enjoy. There is very little vision and craftmanship on the screen, just greed.
I do enjoy a lot of the Marvel movies, because despite them also being heavy on effects, the people making those films care about making a good movie. I can ignore bad or sub-par effects, if the movie manages to draw me in. Most of the Marvel movies have pretty good effects, but there are the occasional hasty effect shots if you pay attention to that sort of thing. Avengers Endgame had some really wonky shots of the Hulk during the finale, and several action scenes in Black Panther looked really bad, like something out of a PS2 game. But we can forgive those flaws, because even if you stripped these movies of all their effects, you'd still be left with a pretty fun movie.
Nolan's Batman trilogy looks so great, because it is a perfect blend of traditional effects (miniatures and sets), and modern effects (CGI). The director cares about the effects as story telling devices, and tries his best to make them look good through his direction and through editing and proper lighting.
Speaking of Labyrinth btw, which
@Zardnaar just mentioned. That movie has some computer effects and motion tracking shots that have not aged well at all. It may have been one of the first movies to attempt motion tracking (which is an impressive feat despite the final product), but it looks pretty bad. It is constantly stuttering and is very jarring.