I held off on watching "Into the Abyss" (2001) because of the grim subject.
After I watched it, I now believe it's among his greatest works (I've watched all of Herzog).
Really worth a watch if you want a peep into how crazy the "ordinary people" around you could be.