Considering how much these questions are asked, you're absolutely right, a summary of the mods should be stickied.
There are 3 popular mods that I'm aware of.
LWAMI is the oldest, currently at version 3.09, and is a database and doctrine mod featuring improved database accuracy, a more sensitive sound-speed relationship, improved AI doctrine, and a large number of fixes for features broken or missing in stock DW.
Alfa Tau is a "new playables" mod, which if I remember correctly, uses the LWAMI 3.07 or .08 database as a starting point.
Reinforce Alert (sometimes called DWX) is another new playables mod, with an original database (featuring significantly reduced detection curves) and original interfaces for the new platforms.
__________________
|