Black Mesa does look awesome. Here's to hoping it comes out in my lifetime...
I'm still waiting on the Jedi Academy -> Dark Forces mod. I played through the first half or so that they released and thoroughly enjoyed it... but where's the 2nd half?!?!?
http://darkforces.jediknight.net/
UPDATE: At least someone was working on it as recently as a month ago...