When I saw the title of this thread, I knew exactly which two games would be mentioned.
Worst based on concept/subject is Custer's Revenge.
Worst based solely on playability is ET.
I never found out who the idiot was at Atari who agreed to play Spielberg $5 for each ET cartridge sold or...