The caveat to "Shades of Gray" is I don't consider clips shows to be bottle episodes. They're glorified "previously" teasers. And there's never been a good one. Ever.
SG1 had a borderline "okay" one every now and then. But they had so many it was more a matter of probability. Trek only dared try it once and it was so bad they stayed away permanently.