As for the whole mycelium plot in Discovery, I found it so ridiculous that I refuse to consider that show canon.
Yes some Trek scripts are better than others, as are some entire shows. But the creators of Disco seemed like they had never watched a single episode of "real" Trek or understood what made it work.