I think modders were much better at using GECK then the first time around with Oblivion. But on the whole, Fallout 3 didn't need the massive overhauls that Oblivion sorely needed. Oblivion's leveling system was, to put it nicely, severely broken out of the box. And Oscuro's Oblivion Overhaul was the only way to end up with a game that made more sense and was more enjoyable.
I still plan on using either FOOK2 or FWE at some point... I just haven't gotten around to it yet. Instead, I'm using a lot of small mods (texture replacers, lighting mods, small adjustments to realism or gameplay) with MMM or DC Interiors being the biggest mods in my mix. There was a thread last week about visual/texture mods, so I won't repeat that list here.
My current load order:
Spoiler Fallout3.esm
PointLookout.esm
Anchorage.esm
ThePitt.esm
BrokenSteel.esm
Zeta.esm
Mart's Mutant Mod.esm
DCInteriors_LEnfntPl.esm
DCInteriors_Georgtown.esm
DCInteriors_Mason.esm
DCInteriors_SewardSq.esm
DCInteriors_Takoma.esm
GalaxyNewsRadio100[M].esp
DelayAnchorage.esp
DelaySteel.esp
delaypl.esp
DelayThePitt.esp
delayzeta.esp
Gifts4Kids.esp
MaintenanceShed.esp
Ammo_Dispenser v 2.esp
Merc Adventurer Armor - eng.esp
HellsDistressedLeatherJumpsuits.esp
LongRangeReconnaissancePatrolLRRPArmor.esp
3EFhelmlessstealthsuit.esp
BD Merged Camo Battlearmor.esp
sunglassescollection.esp
Realistic Death Physics.esp
Slower Degradation (-50%).esp
KarmaHard1010.esp
reduced karma loss for Stealing.esp
choose_XP.esp
VanishingPiles.esp
BlankJournals.esp
Glow Sticks.esp
Longer Days & Longer Nights.esp
PowerArmorRebalance.esp
Random Bobbleheads.esp
RandomizedSkillbooks.esp
RandomExtraTraps.esp
DeadlierExplosiveTraps.esp
Xepha's Darker Nights.esp
Realistic Interior Lighting - BS.esp
Realistic Interior Lighting - OA.esp
Realistic Interior Lighting.esp
PiPBoy Grey Light.esp
PiPBoy Light Range x3.esp
NightvisionGoggles(Powered).esp
Mart's Mutant Mod.esp
Mart's Mutant Mod - DLC Anchorage.esp
Mart's Mutant Mod - DLC The Pitt.esp
Mart's Mutant Mod - DLC Broken Steel.esp
Mart's Mutant Mod - DLC Point Lookout.esp
Mart's Mutant Mod - DLC Zeta.esp
Mart's Mutant Mod - Hunting & Looting.esp
Mart's Mutant Mod - Reduced Wasteland Spawns.esp
Mart's Mutant Mod - Natural Selection.esp
Mart's Mutant Mod - Tougher Traders.esp
Mart's Mutant Mod - Zones Respawn.esp
Total active plugins: 59
Total plugins: 60
Whatever you do - get FOMM and use it before you install any mods. That way you can more easily remove mods that you don't like - without having to reinstall FO3 from scratch.