How do narratives explore the disillusionment with seemingly powerful figures who are ultimately revealed to be ordinary or fraudulent?

This thread traces stories where a revered or feared authority figure, often magical or political, is exposed as lacking true power or being a charlatan. It originates with the reveal of a wizard's trickery, evolving to encompass political leaders, spiritual gurus, or societal institutions whose perceived might is unmasked as illusion or manipulation.