CGI is an amazing art, really, and when it's done well, you don't even notice! That being said, when it's done wrong, it sticks out like an onion in your cereal.
Sometimes it can ruin moments in otherwise great films, and other times it's the whole friggin' film that just looks like garbage. Whether outstandingly terrible or subtly strange, these are the CGI moments that are unforgivable.