teceem: Games that were never released, never shared, and never mentioned to anyone are the most obscure games that exist. I can't give any examples, for obvious reasons, but I suspect their existence.
I can confirm they exist.
Source: I have made such games in the past.
If you restrict this to games that were commercially released, the most obscure one I've played is probably Centauri Alliance. It's like Bard's Tale, except in space, and it had some interesting ideas (technical skills, one playable race that can transform into different creatures), but also some issues (game interface is sluggish, have to press a key to see everyone's current health (especially a problem when radiation is involved), and many gameplay bugs (the worst being that charged psionic items use the wrong memory location when checking for/adjusting the charges remaining when used during battle).
It didn't help that this game was only released for the Apple 2 and Commodore 64 (no DOS version), and it was released when those computers were going out of style.
(As a side note: With the help of an emulator's debugging features, I managed to figure out how to fix that bug I mentioned, but there are still many others. On the other hand, I also figured out how to abuse that bug to get infininite uses of the game's (intended) second strongest attack spell (well, psionic power) early in the game.)
toxicTom: I had this one: [link to possibly questionable site here; game title is Mayhem] on the Commodore C116. The only original cassette we had. I still don't know what you were supposed to do in this game.
Since when was there a Commodore C116? Maybe you mean the Commodore 16 or 128?