Take the movie "Aliens" from 1986 or so. No CGI, it is models, real stunts, real explosions. It still holds up 30 years later. It is an exciting story, within the bounds of physical realism. I wouldn't call Aliens in my top 50 movies, but I like that kind of movie. But they are not made like that anymore. Maybe all the stories have been told.
Only half the stories have been told.
The other half aren’t allowed in Hollywood.
Speaking of Aliens, the last movie I liked was Gladiator which did use a small bit of CGI.