Agreed. For me, the only “magic” Star Trek needed was stories about relationships that took their time unfolding, with competency. There occasionally were unexplained encounters, but the focus was always on something that could be solvable when the crew worked together. There was resolution. Plus, I really liked the episodic structure of TNG and DS9, where I could get onboard with any episode almost. Within the self contained episodes there could be “twists of fate” that exist today. No more giant fantastic leaps than we already make by believing everything is in the future with their tech.
The “new” trek is too focused on being cinematic. Discovery was interesting at the beginning but it was overly precious and predictable, and overly representative. Designed to keep people hooked. I think the quality suffered greatly. I think representation is super important, having characters with diverse identities, but doing it for diversity’s sake isn’t the way. If we’re really in the future, then people just are.
That is my thinking, too.