Yeah I remember Moonwalker on C=64...
Some other games I remember playing on the Commodore 64 are beyond description when it comes to terrible, but yet again some of the simplest graphics games were addictive (eg Jumpman, Beach Head, Raid Over Moscow, Shamus, Summer Games etc...). Gayest game I played on C=64 was Mellon is Thirsty an adventure game for kids...
Worst Amiga game was Mousetrap and several public domain/shareware games they used to give away on Fish Disks (monthly public domain disk for amiga were many gems on them too, someone has probably made an entry for them on Wikipedia...) Dogs of war was crappy but addictive...
As for PC, well Im choosey what I play, can usually spot a lemon when I see it on the shelf. I will read the Big Rigs review for a laugh...
There's some crap games on Xbox and PS2 I've played as well like Narc and this shoot em up one set in the future with a game engine similar to Medal of Honour but harder to control (that was a waste of money hiring from the video store...).