Fans like to see heroes overcome insurmountable odds to win the day. As a result, comic books often indulge their audiences with high-stakes situations and action-packed adventures. However, for non-metahuman superheroes like Batman, who put themselves in the line of fire on a daily basis, the grueling physical altercations slowly take a toll on their minds and bodies. So, when the events of DC's Knight Terrors finally wore down Batman to complete exhaustion, it really emphasized how even the Dark Knight is still essentially human.
Source:https://www.cbr.com/knight-terrors-dc-comics-batman-limits/