Pretty sure you can't.
anyone know if you can access user made content via a PS3? i sold the game, will rebuy if you can... though i doubt you can.
Not sure if I'm just misunderstanding you, but Steamworks games aren't the same as games that will activate on Steam. If you're talking about the latter, Valve keeps an updated (AFAIK) list here:
For you guys new to Steam you might also want to try and keep track of which games are Steamworks and then follow the prices on those games at other stores. It can be a pain some times to figure out which games are or aren't Steam activatible but in general newer games from certain publishers like THQ, Bethesda, 2K, Sega etc. will generally be Steamworks while others like EA will never ever be and Ubisoft with only very rare exceptions.
Edit: BTW, any retail game can be launched through Steam, if you just like having all your games in one list.