Season 8 · Episode 12
The Simpsons
To promote teamwork amongst the power plant's employees, Mr. Burns makes them go on a corporate retreat up in the mountains.

Functions as an exclamation of frustration or disappointment. Milder than vulgar alternatives and widely understood across Latin America.
Used as a standalone exclamation when something goes wrong or when someone is annoyed. Not a literal reference to demons.
Used to describe someone who is tedious, slow, or chronically irritating to be around. Mild in tone, more exasperated than truly offensive.
The construction 'estar/andar hecho un...' frames someone's behavior as resembling a type of person. Adds emphasis beyond simply calling someone a pelmazo.
In context 'quedar hecho trizas' means to be shattered or destroyed completely, physically or emotionally. The expression is non-compositional: 'trizas' alone rarely appears outside this fixed phrase.