Take a look at the featured fixes for GTA SA, for instance. Fixes many game-breaking bugs while adding support for modern hardware (16:9 resolutions, newer Windows versions, etc.), as well as fixing many other smaller problems with the game. I find it essential to playing the game.
That game & this guy's mods are way over my head, but I really love mods. Great article.