This is an interesting site. The site owner has basically written a crawler which trawls through the public Steam community pages and tallies the number of players for those titles that have Steam achievements.
Some sample numbers-
Team Fortress 2: 1,740,658
Half-Life 2: Episode Two: 1,255,624
Portal: 1,247,849
Left 4 Dead: 1,216,644
Call of Duty: Modern Warfare 2: 1,023,973
Left 4 Dead 2: 673,940
Bear in mind that these are only from public community pages, which are less than 40% of the total Steam user base. An IW community fella recently stated that 'millions' of PC owners were playing MW2, so it looks likely that you can at least double the numbers there to arrive at overall sales figures. It obviously doesn't give Steam sales figures as most of these games are also sold at retail, but the full list of the games covered, does show a number of games which are digital download only. Some pretty healthy figures in there.