The client is still rather resource intensive, it's just that computers have gotten so much faster that you don't notice it.

Now, if Valve would ever deal with the download and sync issues, that would be nice.