There was one German mod (Dark Alliances) which I thought was REALLY accurate. It replaced all four sides into alliances. The Starfleet side would have elements of the Klingons and Romulans added in, the Borg would have some Delta Quadrant races, the Cardassians would have the Ferengi to help, and the Dominion had the Breen. All explosions had various sizes of shockwaves (obviously the bigger the explosion, the bigger the wave) with the waves themselves causing damage, so clearly you had to think a LOT more tactically than simply pouring ships into an enemy base, lest you destroy an enemy structure and the resultant explosion wipe out your whole fleet. On top of that, torpedo impacts had sound effects, and the pulse phasers could charge up for a barrage of blasts that usually decimated even the strongest ships (adding quite a bit of authenticity when compared to the hero Defiant of DS9).
The big drawbacks, though, were:
-poor ship choices (why a Shelly class and not an Intrepid? Why an Excelsior with three nacelles rather than an Ambassador? What happened to the Steamrunner?)
-poor scaling (The Excelsior should never dwarf a Galaxy!)
-all this effort into the nitty gritty, and the weapons fire from the wrong spots?
Still, a fun mod all around, if only for the Defiant herself.