Yes, unfortunately you do have to sign in to Steam every time you play. Not much of a problem for people with always-on connections, but for dial-up users it's a nuisance and for people without internet, it's a huge barrier. But Steam is an effective way for Valve to keep people from pirating their software.