Over the years many created maps, mods and videos for this game. I will start by posting my creations and recommendations. I hope many will expand this list.

Youtube:
A mod spotlight for Kobayashi Maru: https://youtu.be/G-ELwlM1Mkg
An indepth review of Bridge Commander: https://youtu.be/kw_kMAClyXM

Recommended Mods:
Kobayashi Maru: http://www.kobmaru.de/ws/index.php?
Widescreen Config: https://www.moddb.com/games/star-trek-bridge-commander/downloads/widescreen-for-bridge-commander

Very nice will be doing a Bridge Commander video myself :)

Can't wait to see it, the BC community made such amazing videos back in the days :)

Nice links, here are some more.

Gamefront is kinda like the main HQ for Bridge Commander mods

https://www.gamefront.com/games/bridge-commander

Another big site is Bridge Commander Central, you have to create a (free) account, but you can see some modders posting thier WIPs on there. The people there can also help you with any problems you might be having with the stock game or mods. It is a little quiet these days, but it is still active.

http://www.bc-central.net/forums/index.php

BCC also has a discord which is more active.
https://discord.gg/usyZz5AG9B

Demon Renegade Studios has some Bridge Commander mods, although it is more focused on the Starfleet Command games.

https://www.demonrenegadestudios.com/

Of course Nexus and Moddb have some stuff
https://www.nexusmods.com/startrekbridgecommmander
https://www.moddb.com/games/star-trek-bridge-commander

Here's my Dropbox with some Gamefront content that was lost/deleted during a tumultuous time when Gamefront was changing hands:

https://www.dropbox.com/sh/a376zq2clh54nxq/AABneOzIRfhCJRJZoWREiWLNa?dl=0

Let me know if you can download the files.