Some mods merely add a few minor elements to the game. It could be something as insignificant as altering how pedestrians look to a small quality-of-life update to the game's shooting mechanics.
Behind Space of Realities is a phenomenal vegetation mod for GTA San Andreas. It's not as complex to use as a full-on graphics mod, but it adds enough improvements to make the game feel modern.