Although not exactly a console game, but I thought Jet Set Willy was worth a notable mention here, due to it's infamous bug which prevents the game from being completed.