I’m a person who liked Disco for about a season and a half until it was clear they didn’t have a clue what they were doing. I was pumped for Picard until it turned out to be a dud in reality.
SNW brings back what Trek has been good at: thought-provoking narratives, true ensemble casts, mostly episodic stories. LD takes what I love about Star Trek and makes fun of it in the most loving way possible – and in the process makes some really good “true” Trek episodes.
I can say as someone who shares your opinions of Disco / Picard that SNW and LD (if animated humor would work for you) are worth trying out.
And just… be careful conflating how those old episodes made you feel (and make you feel remembering them) versus how good they were. You want to talk about bad TV? S1 of TNG was a dumpster fire. But we all feel good about it because of where it led to. If bad new stuff can make you feel differently about the old stuff, your feelings about the old stuff might not be rooted in what you think it is.