Leon's Map pack, Apartment PTK, and Day 13 are really good. There's a map pack called SMC City that I don't see on there that is good as well.
There's a bunch of mods hosted on the site too but the ones that people are waiting for like Black Mesa Source and Goldeneye Source are still in Beta testing.