I don't think I could ever cope with a loved one having the term "missing" attached to their name. From a purely selfish point of view, it would kill me inside wondering what happened to them and the thought that MAYBE they're still alive - while knowing that the chances of that are slim to none.
Now, assuming that my loved one was missing and living in the same condition that Berry was, I would hope for that over death. As long as they are alive, there is still a chance for them to experience life. Sure, life will NEVER be the same for them after such a traumatic experience, but time, compassion and understanding can heal those scars with hope that they can still hope and dream like the rest of us at the end of the day.
If I die today, I'm happy how my life turned out