Ha so I'm not the only one that feels this way! I remember as a kid having infinite patients for games. I would play the same levels over and over again until I finally managed to accomplish the thing. If I got really stuck I would go and look for an FAQ that would help me get through that particular section.
Now-a-days I find I am distracted/and irritated very easily by games. Multiplayer for the most part is a complete write off. I get into Black Ops and most of the time I just get completely owned. I'm lucky to even get a KDR of 1.5 most of the time.
Single player games; well first off if I even try to play more than one game at a time I might as well forget finishing either of them. I like to finish games that I start, so if I'm gonna play a game it has to be *only* that games until it's completed. However if I find I am getting stuck too often in a game I will just give up. If I have to go to a FAQ once or twice fine, but if I need the FAQ just to keep progressing well then I give up.
I tend to like games that have a long drawn out campaign with an increasing difficulty curve. Examples are Mass Effect/ME2, Red Dead Redemption, and Fallout 3 (except for the difficulty curve part). These are all games which I have enjoyed, and finished recently without too much frustration.