I have 3d Studio Max, my friend gave it to me. I never really learnt how to use it but if you can it's quite impressive, if you've played Warcraft 3, the introduction with the crow and the sunlight was done in 3d studio max. It's really awesome looking.

There's another program called Lightwave which is sort of similar to 3d Studio Max I've heard but never tried it.