Hey woopah,
I guess you can consider me the 'resident mod enthusiast' around here since I am one of the few who promotes and plays mods more than commercial games.
Please let me know if you are still having trouble, it sounds like it was zipped and you need to extract it and then install it. I can give you step by step instructions if you need so just let me know.
You can send me a pm too if you want :)
You are already going to a great site (moddb.com) but don't be scared to try all the thousands of other amazing mods!
Current Favorites:
Wii - Muramasa, MH3, Metroid Trilogy, RS2, Okami, RE4, COD, Dead Space, Scarface
PC - L4D, TF2, BFBC2, Killing Floor, Aquaria, Warsow, many UDK indie games
Mods - MechWarrior:Living Legends, Star Wars: Galatic Warfare, PVKII, Goldeneye Source, L4D mods
PS3 - Demon Souls, Way of the Samurai 3
Social Modding Club: ModDb | Steam
