I agree with the comments above - sadly no new games have been around since way back then that were worth modding. Now some people struggle to play the old classics that used to have great mods, like BOTF, KA, Armada.
Heck, the mods on Bridge Commander (such as saucer seperation) are real labours of love and make the game so much more playable - shame the developers never thought about half of it - especially all the different classes of starships like Prometheus, Defiant etc.