CJ will aim Tec9, Uzi and 9mm similar to the way Niko in GTAIV does.

This mod replaces weapons.dat file in GTA San Andreas/data (juts copy and paste .dat file into this folder).

Update1: Fixed pistol animation. I used my old buggy version).
Update2: Fixed ammo. Since I were changing only the Hitman level of my weapon and since both 9mm and uzi are dual wield they have 2x more ammo than the regular one, and I forgot to change these values back to normal wield weapon.

Enjoy 

I know aiming with the mini-uzi crashes the game - I may fix it soon, though I don't know if I will find my GTA CD anytime soon.