- The premise of "Generations" was "Hey, uh, we should do one with Kirk and Picard, right?"
- The premise of "First Contact" was "Hey, people like the Borg right? We should put that on the big screen!"
- Then "Insurrection" was "Hey remember how 'Search for Spock' and 'Wrath of Khan' were pretty grim, and then they did a light one about whales that everyone loved? Let's do a light one!"
- Then "Nemesis" was "Dude, I don't care any more ... how about we just throw them in a dune buggy? and just end it."
See and that's why "TOS" is better loved than "TNG," even though "TNG" is irrefutably the better show -- the "TOS" films were fantastically better than the series, while "TNG" suffered from the reverse. The "TNG" movies just can't hold up to the average episode of the show, therefore they left everyone feeling worn out while the "TOS" films made everyone feel fulfilled to have been friends with these characters for so long.
This is the episode that really put "TNG" on the star-map. From its Wiki entry...
"Many fans and critics regard them as the best episodes of the Star Trek saga, having achieved an almost cinematic level of story and scope. With this episode, and with its embarkation upon an unprecedented fourth season, The Next Generation was considered to have finally emerged from the shadow of its predecessor. It won Emmy Awards for "Outstanding Sound Editing for a Series" and "Outstanding Sound Mixing for a Drama Series" and was nominated for two others: "Outstanding Visual Effects for a Series" and "Outstanding Art Direction for a Series." It appeared in TV Guide's 100 Most Memorable Moments in TV History feature in its July 1, 1995 edition, and also in another issue on the 100 Greatest TV Episodes of All Time."
Incidentally, I made some edits to the Wiki page on Sunday, adding the "Legacy" section.
Given the popularity of the episode, it has been revisited several times in the Star Trek franchise. The subsequent episode, Family, detailed Picard's struggle to cope with his captivity and assimilation. The Borg conflict is referenced in episodes later that season: in The Wounded, Captain Benjamin Maxwell tells Riker that "we all owe you" for defeating the Borg, while in The Drumhead Admiral Norah Satie interrogates Picard about his assimilation to try to humiliate him. Picard's desire for vengeance against the Borg is also a theme of the film Star Trek: First Contact, with flashbacks depicting his capture.
While viewers saw only the aftermath of the Battle of Wolf 359 in the episode, Star Trek fans would see scenes of the actual battle three years later in the pilot episode of Star Trek: Deep Space Nine. The series' protagonist, Benjamin Sisko, had served as executive officer aboard the USS Saratoga, which was lost in the battle along with Sisko's wife. In the episode The Die Is Cast, when a group of Cardassian and Romulan ships are destroyed by the Dominion, Sisko compares the massacre to Wolf 359.
Having said that, "BoBW" is a Riker vehicle -- the whole episode is about how he's always hid behind Picard to avoid getting a command of his own, and then now he has no choice but to be in command because Picard's gone. But Stewart's masterful performance both as Picard and Locutus really jolted that, as the series focus' quickly shifted from Riker to Picard. Influencing this, perhaps more than "BoBW" itself was the show's aftermath, "Family," which "has been named in a number of polls and surveys as one of the two most popular and best episodes of the entire Next Generation series, along with the episode 'The Inner Light.'" These two episodes, plus my personal favorite "Tapestry" (I even have a signed copy of the script from Ronald D. Moore), all feature Picard to the virtual exclusion of every other major character.
Stewart was just too good of an actor to not be the protagonist. Ironically Stewart's gravitas was one of the things that ruined the "TNG" movie franchise, as Stewart demanded constant action scenes for his character, whom he somehow forgot was not - technically - Bruce Willis. From the Memory Alpha article on "Insurrection":
"I said three things: One was, I thought that Picard's involvement in the action line of First Contact had been very successful and I wanted to continue that. My feeling was that the captain should be in the thick of things. You've got to have the captain in jeopardy. Then I talked about perhaps trying to find a lighter tone for this film, I wanted to see our heroes having fun. And the last thing I suggested was that we should develop a romantic storyline that went a little further than the one that I had with Alfre Woodard in the last film. That was a fairly competitive relationship, which ultimately became respectful and fond towards the end - but it was just too late."
So there's nothing wrong with a lighter tone, that's why "The Voyage Home" and "Trouble With Tribbles" are so popular, but here Stewart is demanding sex and violence for his character, which were not what made his character so distinct and therefore compelling. Jean-luc Picard was a bald British man playing a pacifistic French man who quotes Shakespeare, constantly adjusts his shirt, and calls his first officer a synonym for peeing.