After tonight's patch, many users are unable to connect to any steam game or are hanging on Preparing to Launch...
According to the forums the patch has buggered up how Steam accepts user to the network. The normal 2.8million users on during prime time is now at 414,000. There is no known fix.
Stay tuned for updates.