The G1L mod manager is excellent.
G1L works exactly as advertised. Download the launcher and run it; it automatically installs the modding engine for you. Drop the zip files for whatever mods you want to use into the mod import window; it automatically unpacks and places the mod files correctly. Press "Play". It literally couldn't be easier. I'm very impressed.