The remaining popular mods here are unlocks and routing fixes rather than content. The routing fix is worth knowing about if you have ever watched a Sim fail to reach a room.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.