Some of this I guess is semi-intentional dark patterns [1], but it's also a complex space where explaining the trade-offs to "typical" end users would involve a ton of wasted space and increasingly local/offline accounts aren't what a "typical" end user wants, because they aren't an IT Admin and don't understand the trade-offs and probably don't care to. Given no one seems to have a good name for them other than "offline accounts" or "local accounts", which would imply "can't connect to the internet" to "typical" end users, it's hard not to feel that it really probably is a Power User feature and it's as much an unintentional dark pattern simply because we don't have a good name for it and no one wants to explain the trade-offs to "typical" end users.
[1] Though I'm more willing than most to ascribe at least some good intentions to it: settings synchronization is more useful to typical end users than local sandboxes and devices that don't roam basic settings. The ability to recover logging into a device when a user forgets a password is also a huge necessary deal in 2019 because passwords are broken and typical end users have far too many of them. Microsoft also wants to kill the password as a thing in lieu of other factors. Getting end users out of daily password input would be good for us an industry.
(Yes, yes, I know the next three commenters will complain that it's all just for telemetry and surveillance, and I understand where y'all are coming from, but you are also not-quite-correct and it's a debate I'm tired of. Windows 10 has been increasingly better at allowing you to explore all of its telemetry collection and better with each update at providing tools for opting out of individual telemetry. Windows 10 and macOS/iOS are at the same levels of telemetry collection and accountability of such today. The telemetry debate is increasingly not productive nor interesting in the comments on HN and elsewhere.)