Is it okay to use mods for games like Civilization IV

Of course, mods are the spice of video games... just don't expect multiplayer to work with anyone who isn't using the same mod.