Rhythm games.
I have no rhythm in real life, none in games either. Patapon is about as good as it ever got, my times on donkey konga, guitar hero and such just no. Similar story for anything involving musical ability.
I am not an amazing card counter but I am not bad. This works well for most games based on a hidden deck. Going further if I am gambling against humans I tend to just assume any money I put in is lost/what it cost me to play the game and thus can screw around, I do however find gambling so very boring -- someone once made a "would you rather gamble for 8 hours or work for the same money for 8 hours?" type thing and I would rather work retail than gamble. Something like bridge on the other hand I have no time for and thus find myself terrible at.
I guess I have never taken the time to learn to play chess and go to a really high level. It is the sort of thing you really have to dedicate time to and most computer games have a far lower barrier to entry.
Can do fighting games, be they reaction or memory/planning based, but would much rather do almost anything else.
The DOTA/moba thing... give me a good one and I can play it but force me to have to handle all the stupid mechanics (last hitting and what have you) and my patience for it all wears too thin. There could be a good game concept in there somewhere but it ain't the way it is, and I am not entirely sure how I would do it.
I burned out on final fantasy 1-6, maybe also 7-9, clones some time during the PS2 era and have not come back since. I think I mainly just saw through it all and thus.
Things like Civilisation. If I have been playing for 5 hours I get bored with the late game, doubly so if it is obvious I am going to win. At that point if I start a brand new game I will be all focused again, and if I come back to the late game from a savestate otherwise fresh then also can handle it.
Build and rush RTS games. Give me one or the other and I am OK, combined I struggle for whatever reason. I think I overthink the former.
Everything else. Sometimes inconsistent but usually pretty good. Maybe not MVP in all matches but enough to drop the mood of someone that is. This works for me as I am not the one dropping fools like it is cool with pinpoint accuracy but will be the one frustrating your defences, ending your streaks, destroying any prep and blunting your charge.
In real life.
Snooker/pool. For all my physics training and time I have put in on a spear I am truly awful at these. Air hockey on the other hand.