For Sins all you need is the free XSI mod tool. You can model from scratch in it if you want, but most modelers use their own personal favorite programs. Any program that makes models that can eventually be imported into XSI (usually via .obj) will work.
