Depends on what you want from the game really.
Your best chance is to go to the armadafleetcommand.com's mods section and have a look if there are any downloads you fancy:
http://www.armadafleetcommand.com/botf/index.php?name=Downloads&d_op=viewdownload&cid=2
Or alternatively, you can go to the tools section, and download some programs to edit the game - this is useful for both purely editing purposes, and for making your own mods:
http://www.armadafleetcommand.com/botf/index.php?name=Downloads&d_op=viewdownload&cid=3
If you want to edit the game, I would definitely recommend the BOTFed 1.4 editor, (To edit the ship stats) and the BOTF BOTF Building/Structures Editor.
These both work very well, and also come with good explanations of how to use them.
To download anything from the site though, you'll need to log in. Try using the same username/password that you use on this site.
_________________"Anyone without a sense of humour is truly at the mercy of the rest of us."