3Dstudio is a very powerful professional 3D app, but I'm not sure you can say any 3D program is the standard or the best. Different places use a wide range of different products, including custom products.
Anyway, Game is right, 3Dstudio will set you back quite a bit. I think the new version (6) goes for $1500 bottom, and $2700 fully loaded. Lightwave and Maya aren't much better.
3ds max is best for character modeling, maya is best for scene modeling, and anything other than characters. It is easier to learn and use also. Lightwave is very nice for actual animations.
Lastest version of 3dsmax is 7, not 6, and its owrth much more than 2700 loaded. All best 3d rendering programs, retail, fully loaded will range from 4-5k
:BUMP: Also maya doesnt seem to work with my radeon 9600 xt 256 mb's :/ i think its supposed to work with workstation graphic cards. So does anyone know software good for 3d movie making?