Lol I remember that one. The trailer had a song from the Babylon A.D. soundtrack.
Research & Development was by far my favorite Source mod. Definitely worth looking in to. Flesh was also pretty interesting, but there's no combat whatsoever. Minerva Metastasis is great as well.
Edit:Get a Life was good, though it wasn't perfect. It had a lot of content though.
Then there's Curse. That was a pretty cool puzzle mod. It went indie like a year ago and I haven't seen anything about it since. No idea if the project is still going strong.