SSH passphrase dialog missing
Instead of ssh-add, use

ssh-add -A


This uses the Keychain to find the passphrase, and since your Keychain should be unlocked because you're logged in, you won't be prompted.

(Sierra drastically changed how ssh keys are handled by the OS. The dialog is no more.)