And yet, the few times we do see him as captain, he does just fine.
Does he? When Picard is out of commission or presumed dead, he's never taken command without a load of self-doubt & pigheaded one-track thinking. Each time, his #1 priority is to find daddy. BoBW, Guinan has to remind him of his place. In
Gambit, Troi has to scold him about, & then he gets himself captured anyway. In
Time's Arrow, the entire senior staff has to put him in check.
In
Darmok, he's damn near useless. In
Timescape, he fractured the entire space-time continuum, let Ferengis commandeer the ship in
Rascals, does nothing useful at all, when Moriarty takes over the ship, ends up a protohuman in
Genesis, while Picard is gone, (Admittedly not his fault) & I'm not saying he's to blame, but he
is the one in command when the D is finally destroyed in
Generations.
I think the only times he fielded a crisis well, with Picard out of commission, is
Attached &
Final Mission, and maybe
Samaritan Snare. That dude is cursed in my book. lol
Frankly, Riker can only command that crew effectively, when he is not conflicted about it, like in
Unification, or I guess
Captain's Holiday & Liaisons maybe, when he's none the wiser, but let there be something personal going on in it for him, & he's a basket case, by my reckoning. That tells me that in order to perform, he has to have things going his way, no curveballs that hit too close to home, & that is no way to fly imho