Fighting games, most definitely. Medium level CPUs and higher tend to wreck me in single player, and I absolutely cannot stand the way they're played in PvP. Stop blocking/dodging and actually attack, FFS. It's boring. I find there is a lot of dirty tactics/outright cheating in fighting game AI that I can't exploit, and pulling off combos in arcade-style fighting games that require ridiculous button inputs is completely beyond me.
Not great at racing games either, and I'm very hit-and-miss with puzzle games - the Layton series completely stonewalled me because my mind just doesn't work that way. Most puzzles in RPGs I don't have an issue with, but stuff like that throws me completely and honestly I get bored trying to figure it out because I just guess repeatedly until I get it right. A lot of the time I just give up and follow a guide. I am OK with 2D platformers although those are just a question of muscle memory I think. I mean, I died 219 times in Ori and the Blind Forest, and most of that was repeated death in the same spots learning how to get past them until I could do it without thinking about it. Not sure if it makes me a bad player if I can't do these things in fewer tries...maybe?
I'm not very good at most PvP modes generally either, although I think that's partially psychological. Repeated loss demoralises me, so I perform more poorly than I otherwise might. Plus people who play PvP in a lot of titles tend to be those who spend a lot of time playing these games and are much better than me who tends to stop playing once I've finished the single player content. I'm good enough to finish the game, but not good enough to compete with other players, and I guess that's...fine? idk if it makes me BAD persay, just not as good as other people.
I think that's about it? There are a lot of genres I avoid because I don't enjoy them, and enjoyment tends to affect my performance too - I half-arse things when I'm playing just to play something, as opposed to being actively engaged in what I'm doing. I think I'm deliberately bad at some things so I stop playing sometimes...that's my excuse and I'm sticking to it, haha.