The iconic "dun dun" originated in early radio dramas (notably The Shadow) to signal revelation or tension. It migrated to film/TV—think Jaws (two-note motif), Psycho (shower scene stabs), Law & Order (clavinet clang)—and became a meme staple.
Variations include "ta-da" (reveal) and "ba-dum-tish" (joke punchline).