>

Single player and PVP are two inherently different things. If you're into immersion and multiplayer, co-op games are ideal, especially MMOs if World of Warcraft's or Final Fantasy XIV's world are able to captivate you to that degree. Otherwise, yeah, PVP is inherently "how do I use my skills to ensure my victory and also ensure they don't stand a chance of beating me" which is super unfun for most players and spectators for eSports. This is precisely why I like to play arcade dance games like DDR or Pump It Up with other people. There's a sense of competing with other people when you're watching them play in front of you, but it's ultimately a battle between you and the ever increasingly difficult game. I can be playing an easy version of a song while the person next to me has the difficulty cranked up and I'm more than content knowing I'm having an appropriate challenge for me while also knowing what I could be capable of if I play more and improve my skills.
Yea man it’s not that deep. I used to play a lot of sports when I was younger. Several decades of aging + many many injuries over the years have now robbed me of my ability to play sports in any competitive way. 
Video games fills that competitive void for me. I’m well aware of my limitations as a gamer, especially now that I’m older so it’s not bothersome to me that I may only get platinum or diamond diamond ranked in a game instead of grand champion, top 500, or whatever crazy high rank exists in the game. 
I still enjoy competing in a team based environment against another team of humans in order to win a game. >

That's certainly valid too, I think team gameplay is more stimulating in that regard.