I might be wrong here, but reading this makes me think that it's not that you're not into mass appeal, but maybe you're just not into a game that's as competitive as LoL. That's perfectly fine, I feel.
...
You're definitely right about this, and it's something I've been aware of for a long time. I think overly competitive play does suck the fun out of games. I was really excited when I was 14 years old and competitive leagues were just taking shape in the pc gaming world. Oh I had such stars in my eyes when Thresh won that Ferrari at the first Quakecon. Now I fucking hate professional gaming. I wish it never became a thing. I hate being forced to take a game too seriously. I hate not being able to explore a game on my own terms, because someone else has already crunched the numbers and spread the knowledge so that the entire community knows you have to do precisely _____ or you're doing it wrong period.
And I know that there are places where if I said something like that, dozens of people would pile on me with the term "casual" as some kind of pejorative, but I'm not a damn "casual" gamer. It's a horrible term. I've been a gamer all my life. I love them and I take them seriously. I'm good enough to hold my own among a veteran crowd in most types of games. I've been good enough at a couple games in the past that I probably could have played them as a low rank professional. I am very stubborn about playing every game on the highest difficulty, and I try very hard.
Or rather... I play very hard. Because there's something about competitive games now that just is not play at all. There's too much following directions. Too much adherance to "meta game", which is an idea I've come to deeply loathe. Too much work involved in preparing oneself to actually be able to play. It seems like games are specially tailored to the crowd that will sneer at you if you don't like these things.
Like I could never get into the Street Fighter style of fighting game when I was younger. I didn't want to learn the stupid button combinations. Why the fuck would anyone consider that good game design? If you had to sit down and read about all these buttons combinations and combos and spend hundreds of hours ramming them into muscle memory just to be able to eventually enjoy yourself, something was seriously wrong.
But now we've hit a point where there are only two types of multiplayer game -- the type that make you grind for hundreds of hours before you get to the fun part, or the type that makes you hammer down precise muscle memory and study encyclopedias of "meta" lore before you get to the fun part. The indy scene is finally expanding to provide other options, but most of them provide game designs that truly are "casual" and outside of that there are very, very few exceptions anymore. There's almost nothing anymore for people who actually like competitive multiplayer and want a challenge, but don't care to deal with something that caters to a professional level of play.
I want my Quake and Smash Bros style of games back. Games built on very simple formulas. There isn't tons of knowledge to study. No amount of number crunching will give you an edge. Everything that can be done in the game takes very little practice to do. Yet the action is dynamic enough that it's never dull. More importantly, a player does master the game with practice, but that mastery does not punish newer players with an overly harsh barrier to entry. New players are allowed to jump straight in and play. You're not punished with instant soul crushing obliteration for exploring on your own terms, even while competing. Other players have little more on you than a feel for the flow of the game, and a refined ability to react intuitively.
I LOVED TF2 at first. Played it from the first day of beta. Oh how I loved it. Valve was on course to making it even better, but then they diverted and it turned into something weird that doesn't make any sense. They had a truly wonderful idea, but the gaming community just wasn't mature enough for it. So Valve just said "Fine. Fuck it, just.... here. Hats."
League of Legends really is not a game for me. The problem is it's been the fallback title that me, my wife, and our gaming friends can all compromise on for the last couple years. Especially my wife, who suffers motion sickness from any 3d graphics with too much depth or camera motion. It's addictive as hell and when it's fun (somewhere between 1/4 to 1/3 of the time) it is really fun. However, it's purely a fluke that I ever bothered to overcome the intense barriers to entry and got involved in this game. If not for lots of social pressure, I would have left somewhere around the 1000th time that Akali insta-gibbed me before I had any idea what had just happened. Yeah, I picked up this game the week that Akali was released. Right after the release of a new assassin type character is not the time to try and pick up this game...