I'm seeing a lot of games with awesome cover art but pretty standard gameplay for its era. You gotta pick something with truly dogshit gameplay to counter the cover. I present the NES game Dr. Jekyll and Mr. Hyde:

I was the kid who liked to stand in the horror section of the video rental store, look at the covers, and read the descriptions of scary movies I was way too meek to ever actually watch. This comes along, and I think it looks pretty cool! My mom paid good money to rent this and so help me I spent a good chunk of my evening trying to figure out how to do... literally anything. I wandered back and forth as Dr. Jekyll for a while before I bumped into too many pedestrians and turned into Mr. Hyde. Then I wandered back and forth as Mr. Hyde until I believe a bird killed me. Never made it past the first level.

That is a truly horrendous game with badass-looking cover art.