I recall the zoomies effect was used only in "Let That Be Your Last Battlefield" - an interesting attempt, but definitely falls into the category of "overdone". I didn't loathe it, and there's little from TOS in terms of camerawork that comes close to being "bad" IMHO, especially with the equipment of the time...
However, I can one-up this - okay, it's not TOS, but for Trek overall, it's still an award-winning biggie.
I recently sat through some late-70s sci-fi and saw progenitors, but I'll spare the novella* on possible influences, but as much one can credit TNG for taking a new camera angle combining depth of field with a figure coming in from one direction to improve the action, the following is one of the greatest contenders ever in terms of dramatic misfires:
From TNG, early season 3, and never once ever done ever never ever again. Not a bad try, but the last time I saw the episode**, I burst out laughing.(
Also, insert trite gag reference of "spitting one's recently-drank fizzy liquid all over the chair" bit here.)
The only thing worse would be to do an "Airplane!" gag
seriously and have Picard coming in from the ceiling downward. And you know it's bad whenever an idea in a comedy is attempted in a serious show but goofs up***...
* scary, but true
** might have been "The Bonding"? Now I have to rewatch all of season 3... but I'm not going to complain too much...
***
Sliders took a main plot point from
Red Dwarf's "Backwards" and tried to take it seriously. Didn't Quite work. Worse,
Galaxy Quest's intentionally over-the-top scene involving vent systems and the reset switch in the dumbest place for comedic intent was tried several years later as serious, "po-faced" sci-fi... nope, still looked more stupid than sensational... but some people think my taste in sci-fi is stupid too, so it all balances out, it's all good.
On edit; Found it, cuz stuff'n'reasons:
Star Trek Moments TNG - Episode. - 53. The Bonding. (youtube.com)