I tend to look at the simplest term of explanation, because others have dived deep enough to the Mariana trench of technical aspects of always online gaming.
In a product, both as creator and user, we always look to enhance and improve the product, make it more user friendly, durable, cost optimized (see, I don't use the word cheap, because cheap has a negative connotation), purposeful (make it more fun, in gaming situation), and other positive outcomes. This is what generally regarded as good practice in product and business development.
Now, we look at the always online in game. In the first post, OP stated that OP's console is connected to the internet 24/7. This by itself is a simple practice. I live in Indonesia, we have an internet renaissance couple of years back, and now I can say in Jakarta, Indonesia's capital city, outside of the usual 1-2 hours maintenance per month, the internet works just fine.
Beyond that, when we enter the realm of gaming, especially single player gaming, it begs the question of the second paragraph of this post, which is how does being always online improve my experience in single player gaming. Do I get new, particular experiences that I cannot get if I play offline? If not, we move to the next question, which is the other side of the first question, does being always online opens a possibility of negative experience in single player gaming. If the answer to the latter is a resounding yes, then by all means, being always online in single player gaming doesn't give any benefit but opens a possibility to a worse experience.
Now, we each have our own tolerance level toward displeasure and negative experience. Some can just shrug it off, return the game and continue with our life, maybe become wiser with each situation. Some may not have that luxury, especially if they are very much invested in particular games (by OP's term, being old man shouting at the cloud).
As for myself, I think this always online in single player game practice is more on the malevolent side of the equation. They can make it not mandatory, just like now Elden Ring use it (if you are online, you can get indirect interaction with other players), or DMC V (if you are online, and in some stages, you can semi coop with other players), or any other games that doesn't make the always online an intrusive obstacle. These games can still be updated, or patched, to ensure the bugs are squashed, no problem at all. Want to splurge your hard-earned dollar or rupiah for the developer because you love them, and you like that edgy overcoat skin for your devil hunter? alt tab your way to the store page and type your cc number. Then, after all this, what exclusive benefits does always online single player game can give to the user?