Opera never did sign you in automatically - you always have to click the login button on the site. If you are signed in automatically (without pressing the button), that is the site setting a cookie to remember you - clear your cookies.
Likewise, some sites store form data on your computer as either cookies or "site data", you may want to clear that too.