For me it would have to be the Adventures of Dino-Riki.
I died like a million times because it was so hard to play, but one day I got to... the Final Boss! And I killed him! WOW!
Then the game went back to the title screen. No ending.
There wasn't even a "Congratulations" screen!