Couldn't agree more, with just about everything you said -- especially the interpersonal DRAMA (I tend to refer to it as FEELINGS).
Discovery has had innumerable scenes in which there's a proverbial "clock is ticking" situation, with impending doom all around, minutes or seconds to act to save themselves if not the entire galaxy...and they stop...to talk about their FEELINGS. Although I didn't mean to imply that all the writers are bad or that all the writing is bad, this is what I meant about a certain lack of intelligence on their part. I mean, it defies common sense that anyone, not to mention, trained officers and crew, would stop in the middle of an emergency and...emote. And delve into their childhood fears. And have overwrought expressions of empathy, when, back here in reality, someone would be slapping someone across the cheek and yelling at them to "snap out of it". It's just so ludicrous...and yet they've done it repeatedly. It's a really stupid error, so I can't imagine that they're very intelligent people. And of course, I've been blaming the writers, but what about the people in charge? How does it get by the director(s) and producers? It boggles.
Yes, as you said, characters need good, solid interaction. I mean, that's what made TOS so good -- the interaction between Kirk, Spock, and Bones. But they wrote it intelligently, using common sense! It just infuriates me that these people have this obvious much bigger budget and they squander it.
Anyhoo, I think you'll like Michelle Yeoh in STD, but you'll have to be patient for many episodes -- it took the show runners a while to realize what they were missing after they killed her off.