The mentioned “cause and effect” episode from TNG is probably the best. I can’t believe I’m about to recommend something from Star Trek Discovery but “Magic to Make the Sanest Man go Mad” is actually a really good spin on a similar concept.