I thought the article hit this well -- a good game will be successful. And "good" is independent of whether or not it's a multiplayer game.
@fjtorres5591 described the business side of this perfectly. I'd just add that CDPR is another solid example of successful single player successes in the RPG space (my personal favorite developer these days).
My own preference is purely single player, with some occasional co-op or PvP (typically LAN-based) with my immediate family. My favorite games since 1st person 3D gaming has existed are KOTOR (sort of predates viable 1st person), Elder Scrolls 3-5, the Bioshocks, Fallout 3 & 4, Witcher 3 (in spite of only offering 3rd person, dislike that about it), Cyberpunk 2077, and single-player BG3, but wish it had a first-person view and a free camera -- hate that I can't look up and generally dislike 3rd person. I have zero interest in playing a game with strangers. I know millions of others love the multiplayer experience. I suspect there's a sliding scale of people who prefer one over the other and in the middle are people open to either, provided it's done well.
I did like Dragon Age: Inquisition (the only one of the series I played at length), but it wasn't open-world enough for me, felt a bit too linear compared to the other games I listed. I did like the character development and relationships a lot though. But lack of a first-person view combined with the less-open world was enough to put me off the game eventually.