I didn't so much judge the actor, as the character. It's like they were deliberately trying to have a captain who didn't behave like Picard, & that basically meant... a terrible captain, who when left unopposed, constantly made poor choices, as a default
However, as to the OP. Honestly, I don't really have this problem, because in hindsight, I have very much compartmentalized all the shows at this point. Sure, they're all part of the same lore, but I almost never compare them to one another, & that has been a good philosophy as they now continue to add more content
TNG is what it was. DS9 is something different, just as TOS, VOY, ENT, DSC etc... are. The way I feel about each is its own entity, & can't spoil or be spoiled due to the others. I even think of it that way when considering TOS & their movies. The show & the movies aren't the same entity, and while I was very irked at the time the TNG movies came out, now that I've gotten some separation, I've begun to see the TNG movies as being equally unrelatable to that show, just like I do with the TOS films,
That happened right around the time the Abrams reboots happened. I just said F### it. There's no way to relate all this to one another. Accept each iteration as its own thing. Do it now, before this new Picard show shatters you yet again... because it is without a doubt going to
Picard was a little (lot) too perfect.
He was what everyone envisions their commanding officer to be, or the captain of the most special ship.
Sisko was more realistic. Superior officers make stupid mistakes, yep, it happens.
DS9 was more believable.
But I like personally like both almost equally.