Quick post!
I often used to find myself wondering what the "best" kind of 3D modeling software would be for video games.
Autodesk 3ds Max seems best for architecture and modeling realistic game environments, while Autodesk Maya seems best for character animations and visual game effects! Autodesk products also currently are the industry standard for major AAA game companies, because they have been around since the early 1990's. However, Blender tends to be more suited for beginners of 3D modeling and for indie game developers, since there are literally tons of tutorials for it. Not to mention it is constantly being updated, and it can even be used for movie editing, animation, physics simulations, and practically a little bit of everything!
There are positives and negatives to each software you use, and the video I just provided below talks about these ups-and-downs. I found it very informative, and then you can decide which software would be of practical use to you!
I personally have been using Blender because it is free, open-source, and pretty intuitive for beginners! Autodesk products are super expensive, (unless you are a student in which case it is free for personal use) but they are also super powerful. I found this video when I was thinking about the subject of 3D modeling software and the benefits of each one. Blender Version 2.8 comes out in the Fall and it is going to be massive for 3D game developers! I also posted a video about Blender V2.8.
Hope this seems interesting!