That was great!
So there is this story that I heard about Patrick Stewart, and I always planned on asking him if it was true if I ever got to meet him. One fall day in the early 1990s, he is driving around in California in his convertible, when he pulls up to a stop light. Next to him is this van, packed with this large family. They do a double take and start to talk among themselves and point towards Stewart. He gives them a little wave to acknowledge that yes, it is him. And just as the light turns green, the dad in the van, rolls down the window and yells, "You ruined our summer!" before driving off.
And, as we learned years later, neither did the writers....Important note, that was between Seasons 3 and 4 when "Best of Both Worlds pt. 1" had aired, but not part 2, which was probably the most dramatic cliffhanger of the show.
For most cliffhangers, you have a situation where the crew/ship is in a major pickle. BUT! You pretty much always know that they're gonna get out of it, you just want to see the resolution so that you know HOW they get out of it.
But "Best of Both Worlds" had done a very good job of making it look like the status quo really was about to change. We're told about how Starfleet wanted badly to promote Riker to captain, but he was unwilling to leave the Enterprise. They introduced a spunky new First Officer, gave her a good backstory and set up some future drama with Riker. Even the writers say that they really did seriously consider going that direction when writing the episodes. I remember watching it as it first aired, and I absolutely did not know how it was going to end.
They still didn't know what they were going to do to end the cliffhanger, even if we discount the bit about Picard being potentially killed off if salary negotiations went sour.Berman said on the Frakes and Spiner's podcast a couple weeks ago that Patrick Stewart was never going to be replaced.