What happened to Bert Berns?

Could you please elaborate on the mysterious disappearance of Bert Berns? Did he leave any clues or unfinished business behind? How did his sudden departure impact the music industry, especially considering his significant contributions as a songwriter? Was there any speculation surrounding the circumstances of his death, and if so, what were the most prominent theories? Did his family or colleagues ever come forward with any new information or insights after his passing? Ultimately, what legacy did Bert Berns leave behind, and how is he remembered today?