Not as easy at it looks most of the time
How about a game that doesn't require that
much manual dexterity, but will still frustrate you to the point of depression? Well, a good recent example is the Ninja Gaiden games. While not requiring as much memorization as the originals, the Ninja Gaiden games came with the difficulty of knowing when and how to attack, knowing when and how to defend, and knowing that yes, you are going to get your ass kicked sooner or later. It doesn't matter how good you think you are, how good you actually are, or any combination of the two, you will get your ass handed to you sometime in a Ninja Gaiden game. The difference being that some people can handle it, and some will put the game down never to pick it back up again. Speaking of which, I haven't played NG2 since it red-ringed my last 360. That's right, NG2 is so hard it will red-ring your xbox. Well, maybe not.
There's many and more games that have frustrated me to no end. Some I finish, some I don't. I keep them around though, so when the moment's right I can pick them back up and attempt to convince myself I'm better than I used to be. Which most often ends up being the case. But there are those games out there that make me feel so demeaned and used and broken that everytime I play them, I die a little inside. And for every new Prince of Persia, or Bioshock, that won't let you die, there's still an Ikaruga and TMNT(NES) out there that helps you remember that maybe you aren't as good as you think you are.