Simlogical has mods to give your sims more schooling options for their children, a prison mod, and various controllers that do things like make it so your sims can only serve meals in certain places during certain times of day. TwoJeffs has a lot of mods improving how the game treats same-sex relationships he also has the famous Autonomous Casual Romance, which allows your sims to act on their gender preferences and attractions on their own. Like Jeebus said, Simbology and Simlogical have some great mods.
However, if you're a picky jerk like me and want to tweak the game to within an inch of its life, you have a ton of options. The Director's Cut is packed with useful mods, and if you just want to grab and play and not have to concern yourself with possible conflicts, you'll have a much improved game experience with a selection of mods from that.
However, there are so many very annoying, nonsensical, or plain limited things in the game it's worth hunting down mods that improve anything that doesn't satisfy you.
Very strictly, there are only a handful of fixes in the Director's Cut that are necessary to prevent game-breaking bugs the rest is flavor.
