I'd say Source was great. I sank in multiple thousands of hours in that game - but only playing surf_. (The kind where you had to actually kill enemy players, not the kind where you just surf to a certain platform).
I went back to it a couple of years ago, it was all just servers and people with bhop scripts and AWPs.