Before I get to the point; I've been playing STO off and on since it was subscription only, and I've seen it change drastically over all those years. Some changes were great, others... not so much. I've been away from the game for about a year~ now, and just returned a few days ago when some old fleet members mentioned the current event on discord.
Back when I played a year+ ago, I put a ton of work into my character builds, and at the time they were considered pretty strong (not the best, but as close as I could get being a sporadic player). After returning, and doing red alerts and TFO's and endeavors for a few days, the sheer amount of power creep that has taken hold of this game is blindingly apparent.
Back in the day, you'd be worried about finishing a tholian red alert before the time limit was up. Now you have to wonder if it will even last more than a minute. TFOs are being completed faster than some ability cooldowns. When borg tactical cubes in advanced/elite TFOs are being yeeted into oblivion in mere seconds... yea, something has gone horribly wrong here.
There's no challenge anymore, everyone's got a god-ship that can just will enemies out of existence. How does anyone find this fun? If there's no challenge, there's no satisfaction in accomplishing anything. I get that STO panders to people who want to live out their power fantasies as their favorite captains or in their favorite ships, but do you really feel powerful, or does it just make all of the enemies feel mind numbingly, pathetically weak by comparison?
It used to be that ship combat was slower, and more strategic. You had to work to take down an enemy shield facing, and then try to hit that facing with torpedoes before they could maneuver or get the shield up again. Missions could be intense, trying to whittle down powerful enemies while barely keeping yourself alive as fast as your hull and shield healing abilities could cooldown. Back then, even gravity well on a science build was more for control and support, so that you could group up enemy ships for your escorts to torp spread on, instead of being a 2 second death sentence to all but the toughest ships. Cruisers were actually used for tanking, drawing fire and requiring healing so that your escorts didn't get instagibbed by hostiles. We have none of that anymore, and it feels like the soul of the game is long gone.
On a semi-related note, remember when you could warp to earth spacedock and every ship in orbit was a federation ship? Or to Qo'NoS and at least most of the ships were klingon, with a few rare standouts being nausicaan or orion or gorn? It felt like faction unity, at least to a small degree. Now? Disco balls and weird alien ships everywhere, with actual faction ships few and far between.