3Ds Max, Maya, C4D, Blender ect. All have their own quirks and use cases.
Maya - The industry standard for most things that do not require exact dimensions. Also the standard for animation.
3Ds Max - Really geared toward Engineering/Architectural stuff. Things that require exact measurements.
C4D - Mainly used for VFX/Film/TV ect. great for motion tracking. (Not exactly beginner stuff from my understanding)
Blender - Does a bit of everything, and is not particularly better at anything, other than being completely free. Its poly modeling tools are actually great on second thought. Also Blender is not a slouch and is plenty capable.
Houdini - Procedural everything and simulations. This one stands on its own for simulations.
There's also other software Like, Modo, Zbrush, 3DCoat, Rhino... actually that might be it.
They all have their use cases and are all extremely useful. Daz does everything in its own way which is why i left it out till now. It's not a bad thing, but it doesn't quite fit in with everything else I mentioned.
Honestly just pick a place and start. Maya and Blender have the most abundant free info/tutorials out there right now. As well they do things in a relatively similar manner. Since you intend to make games the best thing you can do is just dig in and start getting your hands dirty. You will come across many problems that you will have to solve in your journey no matter what software you use. So the more you learn the more equipped you will be to deal with issues as they arise.
Good luck!