I agree, but then I think that opens the door too much toward having Riker keep the Enterprise and kicking Picard upstairs to Admiral. Even without a promotion, the trauma he suffered would certainly justify a reassignment to a post where he could recover, leaving Riker in command.
I was bothered about what happened or didn't happen to Picard after CoC, as well as, after BoBW.
He regained his command of the Enterprise after both those incidents as though nothing had happened to him. He was not only traumatized by the Cardassians and the Borgs, respectively, but he was also compromised. They messed with his mind.
Realistically, after just one of those incidents, Star Fleet would have trust issues with Picard. Realistically, Picard would not have been given back command of the Enterprise after BoBW and certainly not after both CoC and BoBW had occurred. He would have been reassigned to a desk job or forced to an early retirement.
But I understand that this is a tv show. And the show must go on with Picard as captain of the Enterprise.
So I was kind of shocked by how the writers set up the story for the movie, First Contact.
Star Fleet sent its flagship far away to the neutral zone, away from battle even though the fate of the Earth hung in the balance, all because, presumably Star Fleet couldn't trust Picard in any dealings with the Borg.
I have to give the writers credit for being somewhat realistic in that Star Fleet had trust issues with Picards regarding the Borgs.
(Then again, wouldn't it have made more sense for Star Fleet to strip Picard of the command of the Enterprise and to give the command of the ship to somebody else so that the Fleet's pride and joy could be used to defend the home planet?)
Yet the writers were unrealistic in giving Picard back his command of the Enterprise after both CoC and BoBW had happened. They were unrealistic to begin with. They follow illogic with logic. They turned things upside down. But they got their way. It's their show. I guess they had their cake and ate it too.