For most modern big effects films, I find the most satisfying results come from a blend of practical effects and CGI. The best examples, for me, come from the LOTR films, and many of the Marvel films, specifically Iron Man 3 - there is a feature on the Bluray detailing how they did the airplane passengers rescue scene, and it's amazing.