I figured I'd throw my hat in the ring so y'all can eat it.
I play CS:GO a lot, I used to suck at it but not so much anymore. All the guns are useful, and there is always a time and a place for them, but if you have the money in a ranked game you should be at least attempting to buy a good gun for that price. The community is not nearly as bad as all you make it out to be. In my... 75 some games of ranked so far, I think the team got mad at me maybe once, and since you can report people for being dicks it doesn't really come up much. Maybe you used to not be able to do that? I dunno but you can now so most of the arseholes are week-banned at this point.
DoTa 2:Re Moba's: I have some... 3000 shameful hours in dota2. I'm not gonna defend the community because a lot of them are quite bad, but it's been getting better as valve implements the 'report people for being mean' tactics in that as well. There is sure, optimal builds for certain heroes but it's certainly not a case of 'only one way to play.' There's also the fact that after two or three games of it you'll be skill ranked into a group of equally skilled players and be able to have fun no matter what you do because no one is a 'pro' in the games you get put in.
Hearthstone:I like hearthstone, it is impossible to be good at unless you pay. Enough said really.
LoL:I hate lol, I hate it's community and I hate the developers. Making people either play the game tons, or pay to unlock heroes is not a smart game mechanic, especially when so many of them outright suck.
Complicated games RE:CK2: I always just look at these sort of games like chess, the mindset it takes to play as well as the insanely complicated tactics are what make it fun for some people like me. They certainly aren't for everyone though, but for the nieche of gamers who like to be able to win via overwhelming tactical success... they are quite fun.
HARD games: Dark Souls, and other 'you will die a lot' games.: It may be that I was raised on old games where you quite frequently died, you got reset to level one when you did die, and the game was exceptionally hard. But regardless, I still find them fun, more so than a lot of easier games as there is massive satisfaction in finnally beating a boss that took 10-20 tries. For me personally there's no fun in a game where the chance of losing is never even within sight, aside from really good stories like Walking Dead ala animated novel type things.
Games that _need_ a rule book to learn: Once more... I am probably one of the smaller group of people here who has played a lot of games from the 90's and some from even before that. A good example being King of Dragon Pass, that game barely tells you anything about what you need to do to play it, as it assumes you read the rule book. There was a point in time that videogames in general assumed you read the little booklets that came with them, and yes some modern games don't have those but are still just as abstract. Once more I feel that it's unfair to say that they aren't fun or enjoyable because it's 'too much work' or whatever to read a rule book. Personally I just look at it like tabletop games, you kinda need to read a rule book to be able to play, and once over that barrier they tend to be quite fun.
On the opposite side of the spectrum:Tutorials-Tutorials that you can't skip often make the games unenjoyable for me, Sims4 for example completely destroyed my will to play that game since everytime I wanted to make a new household, I needed to sit through 30-40 minutes of pop up windows. I vastly prefer games with a booklet guide as opposed to a long tutorial since you can read the guide once and then play immediately anytime you want instead of sitting through hours of hand holding BS that you already know.