Is it possible to sign in via password auth instead of the magic link? I am no longer seeing that option

Hi Michael, short answer - no. Prefect Cloud moved to using magic links for authentication instead of passwords.