While he built a career playing villains, gangsters, and grumpy old men, De Niro's most unexpected role was very different. And now it's gone.