CGI can work very well I think. I love toy story and pixar animations and the CGI in transformers is pretty much spot on.
However think puppetry can be better. The end of Rec comes to mind....shudderingly scary, I dont think CGI would work so well there. I also love the labyrinth and the dark crystal.
I think puppetry can be better but for destruction and explosions its way better to use CGI