Apart from hacks to gameplay, you should think about:
1. cleaned 'hood templates to stop the critturs et al appearing in every 'hood the first time you play (see Peasantry)
2. clean versions of the maxis 'hoods if you're going to restart (Peasantry - NB empty is much more radical than clean!)
3. default replacement skins (lots of options, but all better than maxis fugglies)
4. a camera mod that lets you get to the edges of the 'hood
5. plasticbox's lighting fix gets the sunlight the right way round
http://linna.modthesims.info/showthread.php?t=3256346. The CEP files, without much CC isn't recolourable and your CC won't load
7. extra lot sizes if you plan on building a lot (MTS2?)
If you want something to play apart from the Maxis 'hoods, you could try one of the complete user made 'hoods. I've just DL'd the N099 project hood and am having great fun with it!
http://n99forumpaks.jfade.com/old.php?category=91 Mootilda is making a list and reviewing them here
http://www.modthesims.info/journal.php?do=showjournal&j=718