This is the list of top epic mods I have seen so far.
List will expand with time.
Vampire Killer Attack Interaction V3 by Enirei
Vampire Hunter by Enirei
Vampire - Bloody Meals by Diriel
Vampire Covenant - Requested Career by Lily_XD
SimTransformer for TS3 *UPDATED 09/10/2012* by treeag
More Vampire Powers V1.5 by Sauzer