GAMEPLAY:Destruction V6-A realistic destroyable environment mod which does that quite nicely. When you'll shoot at things you'll break them and some will even explode.
Fallout 3 Reanimated-This mod changes many of the third person weapon animations so that the game will look different. The mod is not finished but it works and certainly adds a certain coolness to the game.
Project Beauty-This mod changes the appearance of numerous NPCs (379 according to the readme). It was first aimed at making female NPCs more beautiful (hence the name) but it now caters for both males and females. It's not just a beautification mod either since it changes Talon mercs and Raiders to make them look more dangerous and fierce. Check the screenshots and you'll see how most NPCs have been improved. There are regular updates for this project.
Realistic Sneak Mode-Simply gets rid of the silly sneak caption (HIDDEN, DETECTED, CAUTION and DANGER). It doesn't look like much but it makes quite a difference.
Reneers Invisible Karma Mod-This mod removes the annoying sounds and messages when you gain or lose karma. It clearly improves immersion. There is only one problem it doesn't eliminate the frame that is needed for other messages but it's still a major improvement considering how annoying these messages are.
NPCs sleep tighter-A simple mod that makes sneaking around sleeping NPCs more effective. A must have with Mr Sandman. No more light sleepers!
Hacking terminals is easier-this mod simply removes a number of options from the list when trying to break a code. There are different versions including one with only one remaining password. It might feel a bit like cheating but if the minigame bores you that will save some time for the same result (let's face it, hacking is only a matter of time). Furthermore that mod doesn't make the science skill useless as it doesn't change the skill level required.
Better Stimpacks
-stimpacks now take time to heal your character making Fast Metabolism a more interesting perk and taking stimpacks in combat more challenging (you don't heal instantly so timing and cover are more important). There is an issue with this mod so I'd suggest using a cleaner version
Delayed Stimpaks.
Slow Food Digestion-modifies food the way stimpacks were modified in the mod mentioned above.
Amplified Crippled Effects-this mod makes crippling foes useful.
Super Jump-I've tried the 1.5 version, it makes jumping useful but doesn't break it. A nice addition.
Increased Holstered Speed-A very useful mod, especially if you don't use Fast Travel. It only affects a character's speed when no weapon is drawn.
Marts Mutant Mod-A very big and popular mod, it adds many components which you can choose to add or not. some components will make the wasteland a much more dangerous place. This mod also adds a lot of variety to the wastes as many new creatures and variants are included.
Stalker Mutants Add on for Marts Mutant Mod-This mods adds even more variety to the already impressive number of different creatures in Marts Mutant Mod. It may not be lore friendly as all these creatures are from Stalker but when you've played the game long enough you'll appreciate all the variety you can get.
MMMF3 Increased Spawns-This mod increases the number of spawns (up to 5 times!) and makes the game much more fun (and difficult). Several versions exist. I'd recommend using a mod that allows for extra followers to make up for the difficulty (and the extra XP -followers will slow your progression because you don't get XP for their "kills" but that won't be a problem with that mod). Great if you miss large battles and want an epic feel (try facing 20 raiders at once).
Oh Followers Hire-Allows to skip the Followers limit check so you can have more than one follower. There are different versions, one skips Karma checks and another uses CH to determine the max number of followers. Using this mod will make the game very easy (and crowded) so I highly recommend using the mod above so that the game can be both fun and challenging.
Owned-Allows you to use the houses that are left vacant after the demise of their rightful owners so you can finally sleep in their beds.
Infiltrations-a little mod I've made that will allow you to socialize with raiders and mingle with Enclave grunts if you're dressed properly (I've updated the mod and now there is an option to infiltrate the Talon company).
NPC Tracker Hat-I didn't list this in the item category because it's more of a gameplay change, it will add a hat to your inventory that you can wear to get the location of a given NPC (followers, caravan merchants but also residents of the Wasteland).
Unlimited Death Reload Time-this little mod prevents the game from automatically reloading when your character kicks the bucket. Nice if you're into exploding Lone Wanderers (who isn't?) plus it can be quite funny at times (take my word for it).
XscaPe-a mod that reduces the XP you gain so you won't level too fast (especially when using increased spawns and mods that add content to the game).
Thermal Vision-Three different modes. It's very cool. It works best with
FOSE.