I personally like Carrara Pro from DAZ. But I've been using it since 1998 when it was known as Ray Dream Studio. Its a great all in one program.

If your looking for free I agree with the others Wings 3D is pretty cool. I tried it but went back to Carrara I guess because I'm comfortable with its tools.

Dont forget Blender. Its also a free all in one type 3D application.

Clint