I have mixed feelings about this episode but somehow I think that that was the intention of TPTB. I like that they show how fallible Rodney is and how his arrogance gets the better of him, which is something that they never really managed to do on SG-1 very well, but at the same time I found myself thinking that even someone as conceited as McKay wouldn't put that many people are risk (the first time when everyone was telling him to shut it down) just because he was caught up. However, I think it's good that I was a bit disturbed. It gives you something to think about and I really hope that the consequences of this episode are addressed down the line.
As far as the Teyla/Dex storyline goes I actually quite enjoyed it. It gave more insight into both Teyla and Dex's characters and they, like McKay, were found fallible in their own ways (just not on as large of a scale as poor Rodney). I understood Ronan's reasonings behind his actions but, like Teyla, found the way he went about executing said actions to be a bit shady. And I was honestly surprised that Teyla would suggest keeping something like that from the rest of the team. Might it not be important for them to know that Ronan used Teyla without her knowledge in order to kill a man in cold blood? Even if he may have really deserved it? That may be something that they might want to keep in mind when going out on missions with him but whatever.
I'm also not sure how I felt about the fact that Liz apparently can't say no to Shep and that everybody seems to be aware of that fact. I do think that when push comes to shove Weir is a strong enough leader to make decisions on her own but I'm not sure about the fact that she's swayed so much by Shep's opinion. Of course he is her second in command and she should value his opinion so maybe it's just the ship aspect of it that's making me so leery. I admit to starting to see a bit of ship between those two characters, though I'd not go so far as to call myself a Shep/Weir shipper. Many people felt that the ship between Sam and Jack weakened her as a military officer and as a capable women in her own right and I'd rather not have that talk start up again with different people.