This can be just about anything: from improving the map, adding in-built damage meters, or even overlaying a game of Tetris straight into WoW.
They alter existing game elements or add useful features to improve the all-around gameplay experience. Addons are user-made extensions or mods to World of Warcraft.