After reading lots of reviews, I have a few ideas....
Carrara is more like daz plus bryce..
Cinema4D is for creating 3D animations and compositing scenes...
If you are looking for easy to use programs then these are
1.To animate characters
Poser or daz
2.To create landscapes
Vue or Bryce
3.To create models(no need there are many free available)
Wings 3D or Zbrush(costly)
4.To create 3D effects like starfield, smoke, water etc.
Wax or jahshaka
5.Texturing(painting) a model
Deep paint 3D or Body paint 3d or 3D coat
6.Allrounder
Cinema 4D
7.Just for fun
Iclone Studio
If you are looking to create dreams and wallpaper then just look categories 2 & 4.