Saw this over at TIGSource. It's basically a 3D modeler, but really user (and newbie) friendly. More for organic models though. Also, it's free, so that is really good icing on the cake.
http://www.sculptris.com/
Video here: http://www.youtube.com/watch?v=6DNRg6pdNeE&feature=player_embedded

Looks awesome. Makes 3D modelling look alot easier. Was wondering if they made a 3D program that has techniques that SPORE uses in its Creature Creator.
But alas I'm too used to 3DS Max and Cinema 4D. Will check it out in future.

It crashes quite often. Is it just me ?

It's things like these that are going to really help indie game developers. Looks neat, and I'm sure it will only get better with time.

That looks altogether awesome. I gotta try that out.

The Wolfire blog posted a review and said it would not be any good for video games as it does not have any "poly modelling and map transferring capabilities".

I was on my way to post about it here. It's really cool. I've no experience with 3D modeling at all, but this program is so easy to use that I've already managed to make a few things that looks pretty cool (to me, anyway).
I guess like others have said it might not be the best tool for game development and such work, but for people who just want to get creative and have some fun without reading big manuals and buying expensive licenses, it's perfect.

I'm posting this link to The free software list in an attempt to suggest that you add the software to that thread.

There's also Blender, free open source standard 3D modeller like 3DS MAX which has evolved to be a pretty powerful modeller, that is if you don't get intimidated looking at its interface for the first time. :)

Yeah, the problem with Blender, at least back when I had a look at it, was that it felt like being put all alone onto the bridge of Starship Enterprise, and being asked to just nip over to the supermarket at Alpha Centauri for a bag of sugar.

Haha yeap, it was scary and intimidating to me even though I'm already used to 3DS MAX and Cinema 4D. Cinema 4D especially has such a friendly interface compared to most of the rest. I'll probably try to learn Blender's interface soon, would be nice to have a 3D modeller that I can install and use anytime, anywhere. For now, I'm lazy.

Yeah, I was trying to learn and the main problem is that it doesn't really have a great mouse interface. Most of the commands are keyboard shortcuts only.

Yes, that's the thing. With Sculptris you can pretty much begin to create stuff immediately, there's not much of a learning curve at all. So it's really neat.
It sort of reminds me of the Amiga days, where there were tons of creative utilities like this, and everyone were dabbling with them to some extent. Just for fun. When you need to read a brick of a manual and/or purchase a license that costs more than a decent, used car in order to be able to use these things, it's very hard to justify the investment in time and/or money for those of us who are not going to use these things professionally.
Anyhoo. It's great stuff. Go ahead and download it before Autodesk buys it. :-)

This. Program. ROCKS!
About an hour of playing with it, I ended up with this face. It's so easy.

Thats awesome :)