I haven't used it to purchase a single Valve product myself.
You wouldn't need to, of course. Buy the game in retail, install it, voila, it's on steam, you can add friends. It wouldn't even need to be a Valve game; Dawn of War II, Supreme Commander 2, whatever.
Of course that'll be more expensive than buying it off steam, but, you know.