There are several modeling software packages. They range a great deal in price, approach, and ability to handle various tasks. However, generally speaking, all of these softwares are sufficient for modeling. If you think you have a modeling problem due to your chosen software, that is not the software's problem. It simply means you may need to learn more about the functions of your chosen software. The programs listed below are currently considered best practices, although their uses vary between studios, freelancers, and hobbyists.
If you know one of these three software, then you are in great shape for entering the video games industry. If you do not know one of these three then you may find some difficulties when applying for positions. The reasons vary widely, but a large reason is due to art pipelines being set, having custom tools integrated and having support services directly from the software producer (e.g., Autodesk). An example would be the integration of Houdini into Ubisoft's engine choice when creating the game Far Cry 5.
There are several modeling packages that are no longer actively supported, developed for or generally used by a wide enough user-base professionally that you may come across as well. Among these are:
Computer Aided Drafting (CAD) programs are parametric modeling programs designed for specific uses in machining and manufacutring. While these packages were not originally intended for use in creating games assets, their power and ability to produce highly complex mechanical objects is undeniable. They would be a great resource for any hard surface artist to incorporate into their pipeline. However, these software suites ****do not replace more games focused suites such as Maya.