About half the mods I install work, half don't. I follow the read me files and instructions too. Something to note is that quite a few of the ones that don't work have a lock symbol on the .esp file in the data folder. The ones that don't work are: imperial city unique districts, better cities, and quite a few companion mods. Some of them are a simple extract, copy into data folder, and check on the data files type of mods but even those don't work! The occasional mod will work. I use mod manager and manual installation.
The "lock" is a permissions indicator in Win 7/Vista - it means that these files are set to "private" and cannot be accessed by just any user of your machine, only those you've given permission.
To fix:
Firstly, make sure you do not have Oblivion installed inside the Program Files or Program Files (x86) folders. Install to a new location
created by you, such as c:\Games\Oblivion or whatever you like. Since upgrading to Win 7, I've installed mine in c:\Users\Public\Games\TES4\Oblivion for easy sharing across my home network.
If that alone doesn't solve your problem, you'll need to reset the permissions on the files in your Oblivion folder.
Make a backup of the folder first, just in case you inadvertently blow up your machine or start World War III. These instructions assume you have followed the previous step of re-installing Oblivion so that your Oblivion folder is in a folder you created or in a public location on your drive that has no security restrictions.
To reset the permissions to "default", right-click your Oblivion folder and go to Properties. Click the Security tab. Click the "Advanced" button. Click the "Change Permissions" button. Check BOTH of the boxes at the bottom, "Include inheritable permissions from this object's parent" and "Replace all child object permissions with inheritable permissions from this object". Click "Apply". Depending on how big your Oblivion installation is, it may take a few minutes for this to process. Let it finish and click OK until all the dialog boxes are gone; your Oblivion folder should now be free of little "lock" icon overlays.