I wouldn't have argued except you said it wasn't not having the right friends and then the very next sentence you say your tired of listening to loudmouth morons in MP games. These two statements are telling two different stories.
I hardly ever play MP FPS games anymore and the ones I do play I have 2 different other gamers I game with and we play in 2 man Squads together and don't allow others.
But usually we play co-op survival games, crafting games, rpgs, etc. Our most played recent game is satisfactory. We would often play for hours and some nights rarely talk much we were so involved in whatever build project we were working on. Our main interaction would be "wait till you see this!" Or "come take a look at how I built this fluid piping setup and see if you can figure out where I screwed up".
The wife and I will often play digital boardgames together and she loves crafting and survival games that are not FPS (she gets sick in FPS games).
I'm an older gamer as well (46) and disabled so often lack the energy for as long gaming marathons as I used to play. I still love a solid 100hr+ single player experience, but there are so many games that would just be barren and empty without someone to share the discoveries with in Coop (valheim, V Rising, don't starve together, terraria, etc etc).
It's tough to find another gamer that's on the same page as you *and* has the same timeslots, interests, etc. But if you can find someone like that don't miss the chance to make the friend a play a bunch of co-op. The person I play with the most I randomly met on the torture simulator known as Escape from Tarkov, and yet we hardly ever play anything so soul crushing anymore.
(If I'm not being clear with tarkov I'll just say it outright. It's evil in digital form. If you have always thought it would be fun to be kidnapped and locked in a dungeon by a serial killer you might enjoy the game).