Multiplayer with your friends, in the same room, on the couch or whatever, will always, always, ALWAYS be better than online multiplayer games against some fucks you don't know and are randomly paired up with.
I think a lot of people say they don't like multiplayer, but what they actually mean is they don't like the isolating, sterile, frustrating experience of waiting in a queue to spend five minutes getting angry because the retards you've been paired up with won't get on the fucking objective and some horrible little shit from Boston is calling them a fag over the mic when your team inevitably loses.
I think online multiplayer is fine, but, yes, with friends. Hell, it's what kept me playing World of Warcraft for a long time... I liked logging on and running dungeons and stuff with my friends.
I've only ever seen a handful of games really "work" for me with just rando pickup multiplayer. One of the few, and the only multiplayer game I currently play at all, is Deep Rock Galactic. Something about either the game design, or the community, or both, means it mostly works. You can play the game with minimal communication, most people get how to play it (it's a fairly simple concept), everyone is focused on the same goal since there's really not any point in trying to be a "star"... If anyone wins, everyone wins. Or everyone loses. There's no "other team" except the computer which we can all share a common hatred of. And for whatever reason, the community is largely friendly and positive.
Honestly outside of streamerbait games, are there any co-op campaigns in games anymore?
Deep Rock Galactic, to the extent it has a campaign. Plenty of RPGs - All of the Larian RPGs, for example, most action RPGs like (urg) Diablo, etc.
That's what it all comes down to, basically, isn't it? Local multiplayer games means that you only have to buy one game to play with your friends. Online multiplayer means that you and all your friends have to each buy your own copies of the same game (and then pay an online subscription fee) to play your game, which makes the companies way more money.
It all comes back to nickle and diming the customer.
While I had consoles growing up, I am primarily a PC gamer and have been every since around the 486 era. So "local" multiplayer was only ever at best a novelty, really - other than hot-seat games like HoMM and Civilization, which could be fun. The whole "crowding around a 14 inch CRT" thing didn't really encourage local multiplayer for computers.
Although I remember when it wasn't unheard of for PC games to allow you to install multiplayer clients for free without buying the full game. That was kind of awesome.
Here's an unpopular opinion: Skyrim is a good game.
Honestly, yes, it was. I have complaints about it, but at the end of the day I've played it through several times and enjoyed it. It's a fun time, a zero-to-hero power fantasy in a fairly pretty (Well, it IS a Bethedsa game... They only get so good, particularly their humanoid character models) world with a nice sound track and lots of manly norse beardliness and shouting at dragons. I had fun. I'll probably have fun again in the future.