A login is a login, no matter if you're redirected to another place to perform it or if it's on site. Facebook/G+/GitHub logins don't exist because they aren't used.
It's up to the app creator which ways to log in they provide, but users should basically always prefer steemconnect for security reasons. Be sceptical if someone wants your keys.