Well through my days of gta sa, i have been checking out some cool mods, and for you that have gta, i would like to recommend some awesome mods and ill try to remember the website.

First: GTA UNITED-awesome mod, right now they removed SA and just put in VC and LC later version there will be missions, SA, ect. Right now though they got some small missions, peds, its very fun. (www.moddb.com)
Second: GTA SIMS- Just got this mod actually, but from what ive seen...wow, has functions of the sims, and guitar hero (NOT KIDDING) and many more features (www.gtainside.com)
Third: Skate mod-It lets you acutally ride a skateboard, with a actual animation, its not perfect but i definatly found this mod to be great, there are minor bugs, such as when you get off the skateboard it kills you, but it happens to me when im sitll moving and get off. (www.gtainside.com)
Fourth: High res leon- This is a cool one, but you can only be leon, any other clothes skins will not work, so i suggest backing it up, but it has a option of using the jacket, or without, and it comes with some of the weapons, striker, type writer, handcannon. (www.gtagarage.com)
Well thats all im gonna put, if you guys wanna talk about ur fav mods of any game or even this one than cool!

gtainside
Gtagarage
Gtafiles
Gta-worldmods