Dan Rivera, a well-known paranormal investigator and the caretaker of the infamous Annabelle doll, was found dead in his hotel room on Sunday, prompting an outpouring of grief from fans