I agree that Bakula is the weakest lead of any Trek series. Nothing against him personally. I really liked Quantum Leap, but Archer left a lot to be desired. I did like his take on the character better when he went dark in Season 3 though. I don't fully blame Bakula for Archer; I mean, I can imagine studio interference resulted in a lackluster, too safe, character.
When it comes to Burnham, I feel that in previous shows she would've been the outsider character that potentially became the breakout or scene stealing character who can have unique insights into the human condition or allow for exploration of their unique non-human culture/lives (Spock, Data, Worf, Odo, Quark, Seven of Nine, The Doctor, T'Pol, etc.), but for Discovery, they've put her in the lead, and I don't think we are used to this kind of character also being the lead character in a show. Also I don't know if the writers have quite gotten a handle on how to make a Trek series based mostly on an individual character and not an ensemble show. Even TOS and ENT, the least ensemble-focused of the series, still weren't as focused on one character's journey like Discovery Season 1 has been. (I wonder if this approach will also apply to the Picard series as well).
I think in Season 1, the other characters were supporting characters and treated as such and that has caused some disquiet, as well as some nerd rage, in some corners of the fandom.
Considering what little I've seen of Pike (only the first episode so far), he's sort of in that outsider, side character lane (though more so for the curiosity factor about him due to his place in Trek history) and that frees up the writers perhaps, unlike with Burnham, who both has the outsider status but also the weight of carrying an entire series on a level that other Trek leads have not, because the ensemble concept spread the story/character development around. From what I've heard of Discovery Season 2 we are getting more of that this season with Tilly and Stamets-Culber, and so Discovery could end up being an ensemble series like the others during this season or by the end of its run.