[Alivad]

The "omg non wiedu mods are never compatible" myth is a popular one, but sadly doesn't tell the full story.
You can generally only have one large, TLK overwriting mod, such as TDD or SoS. However, there is an effort to combine the 'larger' mods together in the form of the Big Picture over at TeamBG.
Mods distributed in IAP-SFX format will append to the TLK file the same way WeiDU would, and so aren't ultra-destructive. However, they still overwrite files in the override. These can potentially be compatible with each other and the big TLK overwriters if either they're specifically engineered to be, or they do not change the same files.
Then there are the WeiDU mods you all know and love.