What some game you have liked and otherwise find good that has this one scenario, phase, achievement, or mechanic that sends your overall enjoyment of the game careening into a wall?
For me, I’m currently playing a Super Mario 64 rom hack called Mario and the Multiverse. It’s basically Super Mario 64 crossing over multiple other gaming titles with some power-ups to boot. Fifteen major worlds, each providing one power-up based-on or inspired by their respective world. Now you’re thinking, “Wow! Fifteen Power-ups!? I hope they’re all super cool to use”… or perhaps you’re thinking “Freakin’ fifteen power-ups? Lemme guess, balance issue, ey?”.
I tell you one thing, the game is not perfect: there are definitely issues with it! But there are plenty of great moments in that rom hack. Out of the fifteen, some are situational, a good few are universal (especially the last power-up that breaks the game in half), but there are two significant power-ups that are absolute TRASH in their use!
First is the power-up Chronos based on the game Katana Zero. I gotta say, the power-up’s world in the game isn’t all that good either. Really expansive but very few distinct landmarks that you will get lost rather quick. The boss of that world requires you to use this horrible power-up and the boss itself is ultimately a gauntlet sequence. So Chronos is a move that allows you to slow down time and use your katana to dash-slash. Sounds good on paper and probably great in practice from the root game: not here! The time slowdown barely works and the katana’s hit box is absurdly small and short lived. You’ll more bump into enemies more than actually striking them and it’s real easy the dash-slash yourself into a pit. 9 times out of 10, you don’t even have to use Chronos: however, this one situational enemy type requires the time ability to properly defeat it. That is, if you CAN defeat them being shot to death! And yes, the enemy is part of that boss fight!
Second is the “Esteemed Mortal” that is the saw axe from the Walking Dead… Could not find any practical use of it. Upon activation, Mario’s dives become a repetitive, bouncing, front-flip meant to mow down enemies. It may seem otherwise as you’re using it, but you’re not totally invincible as you bounce-flip. There’s a small window where enemies can hurt you, and it’s real easy to knock yourself out of it by hitting a wall. There’s actually a better invincibility power-up and its home world is labeled a number before the world where you get this one: so most would actually prefer using that power-up over the Esteemed Mortal anyway. I’ll admit, it is fun to bounce around, but it’s very impractical in almost all cases.