I think "once every 24 hours" is reasonable. The problem with most always-on DRM is that, while I may literally always be connected to the internet when I'm at home, the servers at the publisher's end very often fail, especially at launch. "Once every 24 hours" means that, for this to be a problem, the servers will have to be down for more than 24 hours. The problem comes during times when, of course, I'm not online. When I moved into this flat, it took over a month before the internet got hooked up. That was an entire month when I was dependent on my phone for internet. I was also dependent on playing offline, single player games -- which is what the console is perfect for. Having to connect to the internet every 24 hours means that I won't be able to play games that I've actually paid money for at a time when playing games is one of the main ways of passing the time when you have no internet connection. This won't happen often, but when it does happen, it happens at the most annoying time possible. Overall though I'm not too fussed.
Having to log in to your Live account on someone else's computer is a pain in the arse. That's like the most annoying thing in the world, typing your personal password on a screen that EVERYONE ELSE IN THE ROOM can also see, using a freaking twiddle stick to navigate through an on screen keyboard. Nobody is going to do that. I'm not going to do that. I'm sticking with PS4 (assuming this allows you to play with just the disk and no logging in).