The problem with TUC is that it contains plot holes you could fly a cargo ship through. Spock's reason for concluding that the assassins beamed back on the Enterprise is invalid for example.
The same is true of all mystery fiction, to varying degree. Which I guess is the problem with this concept: if something takes place in 1950s Britain, we don't give a flying fuck to the fact that the 1950s Britain is portrayed all wrong, from car makes to telephone technology, and the motivation of the culprit is implausible, and the timetable of the crime doesn't and can't work - but if it takes place in 2290s outer space between the KNZ and Earth, we do care, because we have just enough information about the setting to spot the discrepancies, and not an ounce more.
Star Trek is a preexisting universe, so we don't need every mystery to be 90% exposition before we can get on with the actual crime and its uncovering. But we still need it to be 75% exposition, which is really, really bad for storytelling. Columbo in the 1980s might need to tell us what a "VCR" is before we can proceed; Poirot in the 1930s wouldn't bother to tell us what a "milkman" is, and Holmes can have a plot (rather literally) hang on the "bell rope" needed to call the "servant" to take care of the "bedpan", and we can shrug it off as reverse science fiction, utterly alien stuff we don't need to worry about. But if Odo grabs the phase disruptor from the wrong end, the mystery is
ruined for us, since knowing the business end of the disruptor from its stock is all we do know so we hang onto that for dear life.
It's pretty darned difficult to get stuff like this right. Asimov wrote excellent mysteries in his
Caves of Steel series, and could make us look the other way and say "oh, it's the future" when his characters behaved implausibly or obvious down-to-Earth solutions were skipped. But then he wrote Wendell Urth, and (while creating beautiful character pieces and future vistas) utterly blew it, undoing his mystery with his introductory chapter already (see e.g. the first story where gravity is key, yet the story carelessly begins with a superfluous establishing of technology that utterly negates gravity as a factor).
Timo Saloniemi