The Spiderman movies have such aggressive use of CGI that they honestly seem like animated films for long stretches, but almost everyone I've spoken to marvels at how realistic they seem.
Perhaps my brain works differently.
Did you see Zodiac? There CGI was used for what it’s best for...removing satellite dishes from rooftops to a enhance the sense of period, putting the Escadero Bridge in the background of a scene set when it was still standing.