Haha yeah I'm sure you know that feeling
The fewer mistakes you're allowed to make, the more frustrating it can get. Although, this is a two way street. The more frustrating it is, the more rewarding it'll be when you succeed. This is the drive right there. Whether I'm competing against set patterns, AI enemies or fellow humans.. for me gaming is mostly about improving my play and becoming better at the games I love. Not necessarily to be better than others, I'm mostly playing against myself. Setting reasonable but challenging goals for myself. And I don't like when the terms are being thrown around but this is what separates the hardcore from the casuals. In my book at least :p Either you care to push yourself and find your limits, or you just want to play videogames on cruise.
With that said, it's also nice to play casually and just have a good time with videogames. It doesn't have to be frustrating or rewarding everytime I play videogames haha. I'm typically in that relaxed state everytime I'm learning a new game or when I play an RPG.