The late Queen Elizabeth "loved" seeing things go wrong because it "spiced up her life", her former assistant private secretary has claimed.