For me the issue with competitive multiplayer games is that the lows eventually outweigh the highs.
Multiplayer games are a hell of a drug, lol. They get you very high and can be quite thrilling during their best times.
...but as time goes by they tend to become less enjoyable and eventually you are putting yourself thru stress and turmoil and not having fun at all. It all becomes meaningless and so you have to move on to the next game or wait until your friends group picks one to quicken you once more. You also have to dip out to get the toxic off sometimes. Multiplayer only gaming can be a really cold experience. The little things that were annoyances at first eventually become intolerable and usually, USUALLY the more I play the less fun I have.
For many the highs of the best times with games like this will outweigh the lows, but for me the lows are just too depressing to tolerate. MMOs and games with persistent community and gear and character building really do prevent this but the more niche and narrow and rote and repetitive the game is usually the worse the lows are.
I want to play a multiplayer game that is setup like a real gaas multiplayer but everyone is an NPC. Like a .hack game that was really an AI based single player game but was disguised as one of these live service games. Even have the AI be toxic to you via llm. That would be a unique experience and definitely wouldn't be as soul crushing as dealing with real blokes even if I lost more. It really probably never was the game itself why some of us hate these types of games, but the pool of humanity from which we must fish. With ai this is solvable.