I know. That is one of the most frustrating trends I'm noticing in Sci-Fi. It's like they don't have enough confidence in their writing to sell it as it is. They've got to add shock value to draw in the audiences. Pathetic. And I hope they get away from it as the show progresses (if it does).
In episode 9 "Life", Camile's turn comes up to use the stones to visit earth and is reunited with her lesbian partner. There are some scenes worth skipping there for sure, though nothing as gratuitous as the scene in the pilot. And pretty much whenever you see Camile return to Earth, they seem to try and fit in another kiss or whatever. Never seems to get worse than that, though.
As mentioned above, the very beginning of episode 17 "Pain" is well worth skipping as well.
There is also another scene to avoid between Young and his wife, which I'm pretty sure is in episode 7 "Earth". I think those are the worst of them.
Other than that, most of the show gets away from that nonsense and focuses on the story. Most episodes are fine. It's just occasionally that they get into the shock value. And like I said, hopefully if the show becomes more established they'll leave that crap behind and let the story carry itself.
SG-1 had nudity in the pilot episode. But after that they just focused on the story, and that worked out just fine for them.