What are some really good mods for Sims 3?

Depends on the kind of thing you might be looking for. I know there are one or two players here who are fond of NRaas mods, but you know there's no accounting for taste. :)

Master Controller, Errortrap, Overwatch...and pretty much the whole NRAAS lineup. But the first three...are a must have. That will shut most complaints about crashing up very quickly...since it takes care of the errors that this game tends to produce with the regularity of mating rabbits or field mice and stabilizes the game.

IT doesn't mean that you won't get Error 12 resource is full crashes (this game can only deal with 4GB worth of data and when that resource gets filled. *CRASH). But all the silly little errors that used to cause crashes and early exits from games will be eliminated and stabilize your game to the point where the only crashes you'll get are Error 12.

All the rest of the mods and cc are just icing on the cake. NRAAS is the cake itself.

I still have to take the time and figure out Zerbu's Mod. That thing is outtasight awesome. I particularly want to get the hospital and school working as actual active lot careers.