You remember a game from your childhood that makes you go "Aww yeah, that game was AWESOME!" when you think about it, but if you went back and played it today, you'd realize it's not as awesome as you remember? You talk about it here.
For me, it's Jill of the Jungle.
I can't tell you how many times I've played through this game. It was one of my very first games, alongside Wolfenstein 3D and some early Windows games like Comet Busters. It's a very simple sidescroller. For the time, I imagine the 256-color graphics and Soundblaster sounds were probably a pretty impressive feat for a small team like Epic (yes, THAT Epic) to pull off. The soundtrack by Dan Froelich is fucking amazing too.
Unfortunately, that's all the praise I can think to give it. Beyond that, the sprites and enemies are dull and uninteresting, everything that can be killed dies in one hit, making combat rather trivial, the sounds seem very random (a pan flute note for picking up a healing apple, disembodied laughter if you die from a stage hazard [there's no main antagonist], and such, and all the sounds change between episodes for some reason), and all throughout, it shows that the small team led by Tim Sweeney back in 1992 was inexperienced, undisciplined, and didn't really know how to polish a game.
Is it bad? No. But looking at it objectively, I'd say it's decidedly average, with its only interesting features at the time being the aforementioned 256-color graphics (big deal in the early 90s!) and the fact that you have a female main character.
EDIT: Deleted the hotlinked image AND FUCK AUTOSUBSCRIBE!!!