Reading through these posts it amazes me why Riker wasn't ordered to become a CO of a starship, particuarly during a time of crisis. It was obvious Starfleet and Picard thought he would make a great Captain.
Picard was "requested and required" to take command of the Enterprise-D by Starfleet. Same applied for Captain Jellicoe too, so why was Riker an exception?
I just finished watching this episode again... didn't like it as much as I did back when it first aired. A couple of things really bugged me:
1) The Borg decimated nearly 40 starships @ Wolf359. They couldn't just take out the Enterprise? Picard was assimilated. There was no need to allow the vessel to survive, leaving chances for a future encounter. It made no sense for the Borg to continue heading to Earth without first dispatching the partially disabled Enterprise.
2) The Borg aren't dumb... they're over engineered in fact, with redundant systems throughout. A "Sleep" command is simply that... but to end up with a feedback loop that ends up self destructing the vessel? It doesn't make any sense. The Borg would be too good for that. What should have happened is a "sleep lock", Data perpetuating the command. While doing that, the Enterprise could attack without the crew "waking up"... a virtual sitting duck. Destroy it enough until technological remnants are all that remain... enough to study and learn from some of the Borg technology.
3) There was absolutely no cause for worry about Picard dying when disconnected from the Borg. The Borg self-destruct when certain key implants are extracted, but not when out of range from the collective. So, all Dr. Crusher would need to do is bypass the communication pathways so that the implants couldn't transmit the self-destruct mode at the moment of extraction.
4) The Enterprise leaves the Borg cube all too casually... Worf detected an unstable power build-up. Shelby offered the idea of trying to shut it down so that they could salvage the vessel. Nobody talked about imminent self-destruction. Riker has them beam back, the Enterprise takes a leisurely arc past the ship and then suddenly you start seeing the Borg vessel suffering surface explosions.
At the wrap-up, we have a significantly weakened Federation fleet requiring a full year until restored to the levels prior to the Borg attack. Ship captains would be in tremendous need, especially experienced ones. It makes absolutely no sense for Riker to remain on board the Enterprise. He is needed to command another ship! Starfleet could have easily assigned him a commission. It would only make sense. Remaining behind on the Enterprise would be like ending his career.
Personally I would have liked seeing him accept a commission on board another starship, e.g. the Melbourne II. And then we'd have some interesting episodes with two vessels doing exploration together, rather than just the Enterprise alone. Of course, there could be episodes where they are off on other missions, but most of the time they'd meet up for special assignments. It would have made for an interesting dynamic, one hardly seen in other Star Trek series.