Like 95% or more of the TNG episodes had no threat whatsoever to the federation, and many episodes had no real threat to even the crew, although sometimes they would artificially force some threat from the 3rd parties to more heavily invest the crew in the plot I guess. DS9 went away from that with the whole, y'know, galactic war thing, and Voyager was all about survival of the crew in mega-foreign territory.
I think you could absolutely do a great show using Qhue's ideas but obviously the people behind Discovery would not have been the people to do it anyway so I'm not sure how much of a loss this really is. It's hard to know how much is writers, directors, producers, suits, etc. as far as who's to blame for massive fuckery of concepts.
and nobody remembers those episodes. or do you want more poignant episodes about data and his fucking cat?