I said right in the post that it wasn't all or nothing
And yes, some DID have a bad guy, although I'll say it was more often an antagonist than a mustache twirling villain that everyone seems to want to put in now.
Even when there was KIND OF a bad guy, i personally enjoyed it when it wasn't really the case. Something more like "that which survives", which appeared to have a bad guy, but was really more of a relic/artifact/thing to struggle against. Or to make it easier, I liked the Borg better as a force of nature than as an Evil Queen setup. And no one enjoyed the Kazon.
Sure, bad anomaly episodes, but on the whole, i'd watch every one of them before a forgettable kazon episode, most of the Xindi stuff, and even some Dominion or Klingon war arc episodes. Of note, almost all of the examples you used had a bad guy as a one-off thing and not a recurring role. Not always, of course, but (for example) Balance of Terror was good with Kirk matching wits with his Romulan counterpart, not because it was a bigger Romulan threat strung out. Yes, TOS wasn't serialized like that, but Balance of Terror was definitely a better example than a Klingon episode you could have used, as they were more used as 'generic bad guy' then. Romulans only popped up a couple times, and as individual threats.
For me, the crew against the Universe was always more interesting than struggling against the big bad of the season, which we will waste time on side struggles with until he reveals his ultimate plan in the season finale!
I'm ok with an adversary or competitor, need obstacles to overcome. Just don't want to see bad guy cabals, meetings, or conspiracies that only Old Man Picard can solve (if only he could
remember in time, and with the help of an intrepid young crew that needs his veteran leadership despite his combat experience being 30 years out of date!)