Neighborhood deco is one of my favourite things to find as there's not a huge amount out there compared to other CC but people have done a lot of TS3 to TS2 conversions of rabbit hole buildings. I can also recommend anything by Criquette who's content you can find on MTS and newer things on Tumblr. CuriousB for skyboxes and hood deco. Pleasant Sims has a nice guide for upgrading the look of your hood here: https://youtu.be/q6R9cfTsFgE
If we're talking gameplay mods and not so much objects/clothes/etc. then I have quite a few things that fix annoyances or that just tweak gameplay more to my liking. This isn't everything but they are the ones that stick out most to me. Note these are the places that I originally found them, it's been a few years since I downloaded them so they may be hosted elsewhere now:
Squinge (from InSIMenator) -
- Feed baby (breastfeeding mod)
- TownieNoMemoryloss
Simlogical - Various and depends on what you are looking for but well worth a look as there's a lot of useful things there.
Jfade (DJS Sims)
- Less annoying myshuno
- no zone sound
MATY
- SaraMk has a mod (allowedinlots) that allows hood deco to be placed in lots
- Syberspunk - Quiet Pregnancy (you don't hear the chime after successful Try for Baby.)
- Goggalor - All shiftables
- Pescado - Various. I don't use a huge amount compared to what is available but lots of fixes for annoyances are available there. Basically if something annoys you about the game he's probably made a fix for it.
ModtheSims
- MogHughson - Desk locator (lets you assign a desk so your child always places their homework there), Greeting Cards System, Apartments and Shopping - allows a community shop to work on the same lot that has apartments
- HugeLunatic - RugFixes - If you've ever tried to move a rug with the snap to grid cheat set to off you'll know that it messes up the graphics on the rug, this mod fixes it.
- Arel_91 - Select Your Cemetery
- Monique - Do Homework - Tells your sim child to start working on their homework at 7pm.
- Numenor - Smarter Lights
- Quickshot14 - School Spring/Summer Break
- Rebecah - Puppies and Kittens can use stairs
Simbology - Various fixes and annoyance fixes including
- No Friends for Career
- Self Exploding Bottles
- Simblender
- Smart Beds
- Always flush and Wash hands
- Visitor Controller
- ACR (Automatic Casual Romance)
Sims2Workshop
- No Xmas Tree Fire
- Safe Reindeer Hack
If you want things for your business Retail Sims has a lot of good sets for different types of shops. I've heard the site is closing down soon though so best to get there sooner rather than later. There's also a nice bakery set on MTS (Antique Bakery I think it's called).
Buggybooz on blogspot has a couple of lovely kitchen sets which I use a lot.
OMSPs (One more slot packages) - I use sets made by SilentLucidity, JohnBrehaut1 and AriffRazalin.
Fakepeeps has some adorable default replacements so your babies wear an outfit instead of just a nappy. You can only use one at a time but it looks so much cosier than just leaving them in a nappy.
Hysterical Paroxysm - Default Replacements for the bedding.
Phaenoh - Clean Social Bunny
Awasegg - Ultimate Pet Eyes (I use ice set 2)
Last thing I'll mention is that I'm currently trying out the Honeygold Redux skintone set by Dreadpirate. Not sure if I'm going to stick with it but I like it a lot more than some of the defaults out there as it's more Maxis Match like, it's almost too pretty though.