Grand Theft Auto San Andreas
Ultimate Nos Mod
Here is a mod that has 5 different effects for Nitros (I think?, since the readme is in German). To add these to the game, move one of the "Effects.fpx" to the Models Folder within GTA: San Andreas,
and these effects should show when you use them. This is a highly recommended mod.