Wasn't "Dickless" also the jerk reporter from "Die Hard" and "Die Hard 2"? That's what I always remember him from.
Anyways, I found this episode of Stargate intriguing -- not because of the plot or any of the "twists" or whatever, all of that was pretty pedestrian, but the concept of the memory-altering machine could have made for a really good story. Kind of a Philip K Dick style cerebral science fiction story.
I mean, if that machine can be used to so seamlessly remove or alter someone's memory, how do we know who killed the hot scientist chick? My theory was that it was the other scientist -- not the ex-husband, but the other guy was secretly in love with her, and saw her leaving with Ben Browder, and went and killed her and implanted the memory in Crichton, and then altered the memory so Mitchell saw the other scientist in the reflection. The other scientist didn't have any memory of it because he didn't do it, so when they went and altered his memory they were just compounding the crime. Really, what is reality if everyone's memory can be altered so thoroughly?
Of course, that wasn't the episode we got -- we got a rehash of any number of past Star Trek or other shows which introduce world- or galaxy-changing technology and then throw it away -- they should go back to that planet later this season and find a totalitarian dictatorship preparing to invade Earth by taking over key people with that machine or something -- but of course they won't. But it made me think, which isn't bad for a Stargate episode.