G.E.C.K. (Garden of Eden Creation Kit) - Bethesda's SDK that they released to the public, good for basic mods, but you will need more utilities if you want to get serious.
FOOK2 - Fallout Overhaul Kit 2 - Way to many features to list, a simply outstanding mod.
G.E.C.K+FOOK2=FTW