Time and again, the most thrilling theatrical occasions were female dominated, says Dominic Cavendish