Here's one that comes to mind for me:
https://www.youtube.com/watch?v=5JXcwbUG_CI
A 2600 "classic" from the same guy who brought us the celebrated ET. I have no idea why this game is relatively well-regarded while ET is considered the worst game ever; it is every bit as much an incomprehensible pile of bullshit. You have to use two controllers, one for movement and one for inventory, and solve puzzles for which there are no ingame hints or indicators whatsoever. Essentially you had to memorize the manual and then kinda sorta hoped that it was telling the truth, and from what I gather from the Youtube comments on this game, most people still never even got close to beating it. I'll give it points for ambition as it's one of the few action-adventure games on the system, but it's virtually impenetrable to all but the most dedicated.
As a 5 year old kid, I obviously wasn't one of those people, and so the game consisted of me moving around aimlessly for a few minutes and then playing Keystone Kapers instead.