What do you mean by "good modding program?"
For modeling, Milkshape and Blender are popular.
Scripting, all you need is Notepad.
Mapping, mission editor and torque constructor? I'm not experienced at all with interior mapping.
Decals, any graphics program, such as Paint, Paint.NET, Photoshop... preferably with transparency tools.
Sounds, audacity.