The image you posted is from "Rustboy".

The tools used to create "Rustboy" are Infini-D/Carrara. (I guess you didn't read the "Rustboy" site to carefully or look at the back of the Carrara 2 box at all).

So, is it possible to do stuff like the image you posted in Carrara? Well, yes. That image was created with Infini-D/Carrara.

However, Infini-D/Carrara are simply the tools. That image is really the result of Brian Taylor's talent. So the real question is not if Carrara can do it but if you can do it with Carrara. If you have talent similar to Brian Taylor's than perhaps you can.