C4 have lot of top notch features indeed, but programming in C++ is not an easy way at all for 3D artists.
If it had hight level functions for blending animations and all other stuff : i would buy it directly
Some users made a visual animation blending editor. I saw it in a video, very impressive. You could wire and weigh different animations just like you need them.
And, yes, you are right. You cannot make a game as a pure artist. I think this will not work in any engine, unless you, as an artist, start to learn programming.
But C4 is optimized to bring artists and programmers together in a project. A programmer can code functions and can expose them in the visual script editor. So a level designer can use it for stuff like moving objects, scripted sequences, visual effects, whatever.
It is just a professional tool for teams.
But you can have fun as a level designer or artist with it. You can download the free demo and you can use every tool included, you can make levels, create scripts and you can make a complete little game based on the included demo.