Some of the first season of TNG is pretty rough, but that's understandable. It's amazing, overall, with the final episode providing an excellent closure to the seven-season series. That final two-part episode (usually now merged into one), All Good Things, takes place simultaneously in three points in time (though we view it from Picard's perspective in a more-linear way) and contains an overarching plot element directly related to the first episode, S1E1: Encounter At Farpoint.
I love Stargate Atlantis. The writers were superb and the action choreography was provided by an action choreographer who is among the best. I like all five seasons, though the first was a little rough around the edges, as is the first season of a lot of TV shows. When the actor Jason Momoa became a major character (Ronon Dax) early in season 2, he was a good addition to the show. Year after year, SGA's budget increased and the special effects and quality improved accordingly, but by the end of the final season they knew SGA wouldn't be renewed and made some episodes for fun, which worked pretty well. (Brain Storm, with Neil De Grasse Tyson and Bill Nye (as themselves), and Vegas, which was a cool dual-universe "what if <character> hadn't made <x> decision?" show. Very little of Vegas was filmed in Las Vegas, Nevada, since British Columbia (where all Stargate TV shows are filmed) contains all biomes of Earth, including desert, and it's cheaper to film closer to home.) Oh! Things that occurred in episodes from season 1 are referenced multiple times throughout all succeeding seasons, so don't skip it.
I've had Czech friends (online) who loved it for the Czech character, who talks in Czech when excited or frustrated. Rodney (played by David Hewlett) is Canadian, as is his sister Kate (who plays Rodney's sister Jeannie on the show), so there's some real-life sibling jesting going on there!). The Scottish doctor is played by a Canadian actor. I think his parents had been born in Scotland or something similar.
After the Scottish doctor (my synapses are dying or something, sorry.. I should know his name and that of the actor who plays him) left most of the show to go do his own thing for people in the fictional Pegasus Galaxy, where most Atlantis episodes take place (he was brought back after many people protested his removal at the Vancouver studio), the doctor who was brought in was played by an actor (actress) you'll recognize as the engineer from Firefly. You'll also recognize a hybrid human-Iratus bug Wraith character named Michael by the humans on SGA played by the actor who played Trip, the engineer from Star Trek: Enterprise. If you're familiar with those other shows.
(I learned much of this from DVD extras and/or director's commentaries for episodes on the DVDs, including that the second-highest-paid actor for anything filmed in Canada must be Canadian.)
Most of the actors from SGA can be seen in the movie written and directed by David Hewlett entitled A Dog's Breakfast, including Christopher Judge, who had a couple of appearances in Stargate Atlantis in his Teal'c role from the Stargate:SG1 TV series. Kate Hewlett, David's sister, plays the sibling role in ADB as well. The actor who played the Scottish doctor plays a couple of roles, and a few other familiar faces from SGA make brief appearances. I watched A Dog's Breakfast the day after I streamed the feature-length film Stargate Continuum, and I noticed that the cereal box prop used in the beginning of ADB was the same one used at one point in SC. I think they allowed David H. to use some of the SGA set in ADB, too, though most was filmed in a house that was for sale and was about to be moved into by its new owners, IIRC. It had to be filmed in a hurry, so it was helpful that the actors had experience working together.
If I've left out anything major, please feel free to chime in. Thanks!
Oh yeah! In the episode(s) where a replicator gets loose on Earth, she's played by the actor who had formerly played the Purple Power Ranger. Ahh, connections.