Definatly the scene in Thud, when the deep-downers attack Sybil and young Sam. Especially after the shock Vimes got, when one of the dwarves went into the nursery. Seriously, this would make every sensible father cry of sheer relief.
Actually there are a number of scienes with a lot of tension in Thud.