‘Though famous for playing many monsters, he was a hero in our lives,’ actor’s agent said