I won't say that I played a lot of outright terrible games, but let's see:
* "Musashi no Ken" for the Famicom. It's a frustrating side-scrolling platform where some enemies and obstacles spawn so randomly and so often, passing through them is more luck than skill. Also, the B and A buttons are reversed.
* "Taxi 2: Le Jeu" for the Dreamcast. It's an okay, if kinda sub-par graphically, racing-like game (you very rarely race _against_ anything in it), with a really frustrating first level, that's very long and has a very harsh time limit. (I had a pirated version that translated everything from French to Russian, and while the translation was obviously terrible and buggy, it's better than nothing because I don't speak French.)
I also had a PS2 for some time, but I had no idea what games for it were good or not and my parents usually just bought shovelware licensed games, not knowing any better. The only PS2 game I actually bought for myself was "GTA: San Andreas", and I already had a PC version of the game at the time. (Come to think of it, I still don't really know a lot of good PS2 titles, outside of MGS2 probably...)
____________________