Short version of what Kravenwolf said:
Fenix has everything you need.
PB has everything you want. (but is $28)
Those are the only 2 real mods on the market for X9. All others have been integrated on some level. And they are both being handled by our coding god, Hockeykid. (I'd have to say he's about one level down from Lee himself.

)
One promising mod that is beginning to take a spotlight is RPG mod, which is supposed to add lots of storytelling/character building/Overall RPG-esque features to FPSC. That's being developed by F l a t l a n d e r and Blackfox.
There WAS Xara Mod...But it was discontinued as the creator was banned. He developed it from CorVus mod, the new name for Cranox mod. All he did was add some mew shaders, IMO.