That man was truly a wise, wise, man. I hate the memory errors, the 'mysterious disappearing game' crashes, the 'your map differs from the servers" error (which I found was due to the soundcache file, of all things!), the random bugs every update seems to add, and the wildly variable performance hits of each update.
Of course, most of this is Source rather than steam, but the whole package stinketh like a day-old dead skunk on a 90° day...