You're online now, I'm not sure I understand your issue with connecting the Xbox One once. The system plays games just like a PS4, you don't need to be online. The PS4 also has many features that benefit from being online or at the very least updated.
Trying to Answer
For me it just is the carrot vs stick mentality. The 360, WiiU, Switch, PS4, etc. All these great machines start out as a game machine. You turn on and play. You go to a friends house and bring the console, you plug in the power and the AV and your friend can create an account and play.
Plus there is online. It is a great carrot to have downloadable demos, WiiWare indie games, updates and patches are on balance also useful. Expansions and DLC can also be another carrot when a developer treats it as an opportunity to delight and serve a customer. I'm not against any of that. As you said; I'm online talking to you right now. Online is a great option and feature.
With the XB1 it is different. The XB1 on initial startup requires an online connection to play anything on it. This is a stick not a carrot. I'm being corralled. If I go to a friends house and I want to create a profile for them I cannot do that. I have to string ethernet or ask for access to their wifi to create a full profile. Sure, they can play as a guest profile, but then they can't save their progress. Again, another stick when this could all be a carrot. Xbox GamePass, Xbox Live, even downloading of Xbox 360 and Xbox games from your disc are all carrots that would have the same effect for Microsoft (Getting people online.) but without feeling like I'm being forced.
I'm not alone in this thinking. If you do a search for Xbox One Offline Profiles, there are many threads on xbox user voice, reddit, gamefaqs, etc. requesting this.
Off Track
At this point I've derailed the thread. I think I've answered your question, but if I haven't feel free to PM me.
On Track
To contribute to the thread: I would avoid any console that didn't have a physical media option. The PC is my diskless/cartless game machine and features like offline media and local couch co-op are what I value in a console. Thankful Nintendo and Sony offer that now, and I'm very very hopeful that both of them will do so in the next generation.