Some notable sites do not even have passwords — all login is done via email or OAuth.
I can't say I've ever come across a site that only allows login via receiving an email every time you log in or using OAuth. Do you have specific examples of these notable sites?
