You asserted that the spore drive is gibberish that takes away 'one of the things that made [Star Trek] special and successful in the first place'. It has nothing to do with your opinion of the show, which you are completely welcome to, to point out that Star Trek was dealing with concepts (either in 'The Cage' or 'Where No Man Has Gone Before', if you prefer) as far-fetched as, if not more than, the concept of the mycelial-network-as-transport-mechanism, since literally the first episode.
No, I said that about when the creators of Star Trek productions ignore science in general. That's the key. My argument was general, not granular. From the start, Star Trek has tried to build a relatively grounded, believable SF universe (at least compared to the lazy drivel that passed for SF on other shows), while needing to compromise its plausibility on occasion for dramatic or budgetary reasons, and sometimes its attempts have fallen short of credibility due to the writers not being scientists. But at least, overall, the producers tried to make something less utterly stupid than the other SFTV shows on the air at the time. At least they made enough of an effort to figure out the grade-school basics the other shows got egregiously wrong, like what a galaxy is. Even though TOS had a lot of silliness, in balance it still came out ahead of every other SFTV show from the '60s, '70s, and '80s, if only because those other shows didn't even make the slightest effort at plausibility. It tried when nothing else did. That's what matters, that it tried, even though it frequently fell short.
By contrast, these days we live in a time where a greater drive for plausibility in mass-media SF is finally starting to take hold. We have hard-SF movies like Interstellar, Europa Report, The Martian, and Life, and at least one hard-SF TV show, The Expanse. But Star Trek is no longer at the vanguard of plausible mass-media SF. Its makers aren't really trying to make it grounded anymore. That's what's been lost. It's just one more way that Star Trek is no longer at the cutting edge of SFTV and has become just one franchise out of many.
As someone who grew up in an era when Star Trek was exceptional, was head and shoulders above the rest of SFTV, I'm glad in some ways that the example it set has been emulated and has spread to other SFTV, to worthy successors like Babylon 5 and Stargate. But I also regret that it's no longer leading the pack, and that so many viewers today just see it as one more show out of many and don't realize what was so extraordinary about it in the first place.
As much as I like Q, the character, I have to agree.
The only thing that makes Q work is John DeLancie's performance. Conceptually, the character is ludicrous. He's basically Mr. Mxyzptlk, except he's harder to get rid of.