For an example off the top of my head, I know Wolf of Wall Street had a lot: https://www.youtube.com/watch?v=bP2sJqoZD7g You can search youtube for the title of any movie and "cgi" or "visual effects" to turn up tons of examples. David Fincher's movies have some great examples.
And to hop on my bar stool and opine, I think CGI is going to lead to a revolution in filmmaking over the next decade or two as it continues to get better and cheaper. There's ubiquitous criticisms that movies the last couple decades have been so expensive that studios only put money into blockbusters, or meddle in the creators' vision, or only fund simple action movies that are easily translated, etc. When low-budget indie films get access to this stuff they're going to to have the ability to make all kinds of movies rather than just contemporary character studies with limited sets and props. (Digital distribution will help, too.) CGI will be a landmark revitalizing force for movies, much bigger and stranger and better than the New Hollywood movement in the 70s.