Any Source mod needs HL2 and usually the Source SDK. It doesn't have to be on Steam, but since the only way you can play any Valve game nowadays is on that program, it's inevitable...and yeah, PC only.
I reaaaaaally can't wait any longer for Black Mesa.
Insurgency and The Hidden are also some awesome mods out there at the mo.