Help me decide what 3D modeling software is the best fit for my needs

If you’re really just looking to pump out some of your own 3D models that are nothing complex, and not looking to become a professional 3D artist, then I’d say go with Blender. Simply because it’s free and you won’t have the headache of trying to adjust to it from previous 3D program experience.

As many others have pointed out: for an independent user /Maya are pretty unreasonably priced.