Games like Spelunky, Super Meat Boy, Geometry Dash, et al, don’t bother me since they’re basically built around dying all the time and there are no loading screens or anything to deal with. They’re also so technique oriented that I always feel like it’s completely my fault when I die.
When I look back on the games I’ve played I feel that racing games in particular have given me far more rage-quit moments than any other. It’s the fact that you can play flawlessly for 99% of the race, and then make one mistake on the last corner and lose. And of course for the vast majority of racing games out there, you’ve got catch-up physics to deal with as well, which means that you can ram some asshole into a pole and be 20 seconds up on them, only to have them right back on your tail 40 seconds later even though you’ve driven perfectly, simply because the game gave them the ability to corner at 200 miles an hour in order to keep the race competitive.
That kind of cheapness is what makes me rage-quit more than anything.