(Caution - Requires special install method to work, see link) The I-HT fix, which fixes a bug left in the game, allowing I-HT to provide R$$$ jobs. In short, listing all the big mods like this doesn't really help, I suspect if you are starting out, you need the basics first:
SimFox's Day and Night mod requires that buildings are made/rendered specially to work with that. CAM requires special lots that are designed to work with it. SPAM (SimPeg Agricultural Mod) & CAM (Colossus Addon Mod) simply don't work together. There are simply too many mods to list and not all of them are for everyone, for example: The real answer isn't us listing out favourites, it's you deciding which you like. You know, this is like asking us to list all the chocolates you should have in a box of them.