It's good when you don't know something is CGI as it looks "real". It's also good when CGI is used but no one notices, like adding more people in a crowd.
With the right budget, I think almost anything you can imagine can be done in CGI now. With big-budget movies, I expect the best.