The dev being a tranny doesn't ruin a game. If a game is good, it's good. Finding out that the dev is subhuman doesn't make the game not good. A shitty fanbase only ruins games if the online community matters or if you give a shit about what people think about you playing the game.
On the actual topic, warm beer is an example of wasted potential. Something that could be good done right, but presented in a way that doesn't highlight the good aspects the way they should. Usually, it's games with perfect mechanics, control, and interesting possibilities that are never correctly utilized. Nintendo is the king of this problem:
* Zelda: Skyward Sword having good motion control that only services bland cookie-cutter Simon Says combat, beautiful LOD shaders making the distance look like an impressionist painting but only giving you clouds to look at at a distance, and an effectively unused stamina system.
* Super Mario 3D World having tight controls and mechanics and the potentially-interesting cat suit, but 95% of the game is trivial, and only one stage is really very good. The cat suit could be used for interesting climbing puzzles and difficult jump and dash sections, forcing you to maintain memory of the layout of the stage to properly dive in the right direction, but instead just ends up being an overpowered easy-mode powerup.
* Pretty much everything about Breath of the Wild. Big world with nothing to find, the great idea of shrines being a ton of mini-puzzles but end up not feeling like they're even part of the world, destructible weapons with no way of repairing them just becoming an annoyance, limited weather patterns making most areas just either one biome or normal/rain, giant dragons that occasionally roam the world but you can only minimally interact with them in a very specific way, an actual hard mode available from the beginning but turns everything into an endurance contest because the weakest enemies take 10 fucking minutes to kill from the beginning of the game.
* Super Mario Odyssey's capture gimmick in general. It was fun at first, and the worlds are actually great and fun to explore, but capturing becomes an annoying chore pretty quickly, and it becomes clear that most of the worlds would be better and more fun if they were just designed to be navigated by Mario normally.
If you want squandered potential and good games that should have been great, you can always count on Nintendo.