It'll depend mostly on which game (and to a certain extent, which mod). Some games let you just extract a mod into the correct file structure in the main install directory and then automatically detect and load them. Others require you enable the mods individually. Still others require you to...