If you only want to find game patches or Steam manifests, you can browse as a guest.
You do need an account to read most of the forum. The main Steam Content Sharing section is publicly viewable. You only need an account to: cs rin sign up