Remember when Jurassic Park came out, how impressed we all were with the dinosaurs?
Remember when T2 came out, how impressive the liquid metal man was?
The problem isn't that CGI is "bad". It's just a technique, that can be used well or poorly like anything else. It's mature enough now that you can use it a whole lot. But there's nothing intrinsic about it that makes it less impressive or less verisimilitudinous or less worthwhile to watch than other filmic techniques.
The real problem is that "lots of things moving at once look at the spectacle!" is no longer novel. We have scads of movies every year come out that show us that. So, when Jurassic Park had cool dinosaurs, it was *the* movie that had that. When Return of the Jedi had fighters flying all over the place in a massive space battle that upped the ante from the previous two Star Wars movies, it was fresh and cool and new.
Nowadays, that's just same old, same old. You can no longer impress by having lots of specatcle out there, because audiences have been there and seen that. it doesn't matter how you accomplish it -- CGI or otherwise. CGI only gets blamed because that's how people usually accomplish it nowadays. Maybe you can blame CGI because that's what made it cheap engouh to be overused so much. But it's not CGI itself.
Done well, it still entertains. Somebody else has already mentioned Mad Max. As another example, the speedster running through the exploding house scene from [i]X-Men: Apocalypse[/i] was a lot of fun, because there was more to it than just spectacle. The same movie at the end had lots of crap flying all over the places in a special effects spectacular, and it was kind of boring, because it was just gratuitous spectacle for the sake of spectacle, and that's old hat.