In a game of this genre, mods probably won't be possible. The developers have to get this one right.
Well, I agree with you that the developers have to have a solid product with STO from the release date. It has to stand on its own, and stand well. But, user-created content will be very important to the longer term survival of STO. A developer can only put out so much campaign material.