You need to append '' (ie simulate enter)
(echo 'MY_PASSWORD'; echo '') | sshfs user@ip:/home /tmp/home -o password_stdin
works fine as it doesnt wait for any other input.