One additional mod in the vain of FWE that I'd recommend is FOOK2:
...and Mart's Mutant Mod:
You'll need to use the Fallout Interoperability Program (FOIP for short) patches to get them to work together, but it's certainly worth it IMO:
Really, any mods by weijiesen are tops, including EVE and his power armor mods:
And of course, RH_IronSights by roguehallow. This is a MUST HAVE...I can't stress that enough. I can't play FO3 without this mod, and most of the really good weapon mods have mesh patches to work with it:
Those are just a couple of my top picks...all the suggestions by the other posters are really good as well. You really can't go wrong with any of them.
“Ignorance is curable, stupid is forever.” - Robert A. Heinlein