Just thought I'd throw this out, red meat, you know.
Not to put too fine a point on it, but the Borg, like Q, in my opinion became less interesting and more banal the more they were on screen.
I rather liked the idea of an enemy whose existence was totally subsumed into a hive mind. The introduction of some mega-Borg queen seemed to belittle the whole concept.
Likewise, I also felt that Q became increasingly stupid, especially in Voyager.
I'm just writing this thread to complain about two of my Star Trek pet peeves.