Ah, this is solely about trashing Elementary as an imaginary vindication of Sherlock. Well, Sherlock fails on its own lack of merit. Miller's Holmes interrupting the opera is mercurial enough. It just comes across as a little tacky and petty. What it isn't, is being as cool as Cumberbatch boasting he was a sociopath, not a psychopath, get your terms right. Given that the supposed distinction is not actually getting the terms right, I think that neatly exemplifies what's stupid about Sherlock.
Pete and Myka however are a terrible example. When the two leads on Warehouse 13 are both in real relationships simultaneously for more than a couple episodes, then we can start talking about definitively established Platonic relationships. The Middleman example rather reinforces the point about the expectations of sexual tension, unresolved or not. One of the things to see about Elementary is whether they can stick to this premise.