One of my favourite horror movies. Yes, the CGI is not perfect, but the atmosphere is brilliant. The ending stays with you for years.
What Darabont wanted to show with this movie is, no matter how bleak the situation may be, just hold out a little longer. Sounds cliché, but in the context of the movie it makes a lot of sense.
Now the tv show on the other hand, that is a complete mess - stay away from it.