The security implications are one thing, but another issue to me with email codes is that you now have to wait for an email to arrive. At worst this can take a few minutes, at which point I'm no longer interested in logging in, unless it was for something I absolutely have to do. At best I have to open my mail client or log in to the webmail, while with a password or passkey all I need is Keepass running.