In principle it is a good idea, but I've rarely heard people talk about the danger of it escalating to three, four or five factor authentication. It happens to me frequently. I just want to log into some random account and have to provide a password, have my phone, scan my face with my phone, provide a different password and manually copy a one time password. I'm not talking about the case where I forgot one of the passwords, just the regular login. It can be quite annoying.
Don't get me wrong. Please enable two factor authentication whenever possible. It is really a lot better to jump these hoops every time than having your identity stolen.