It's best to just sit back and wait for the reveal. Assume that the twitter crap was trolling (and yea I'm giving a little wiggle on that), assume that always online is exactly the same as what we're doing now, and assume that apps requiring a connection are the ones in debate (netflix, music, bing, etc), and we're good.
Would I like a system that syncs all of my purchases? Yes. Would I like a system that updates automatically assuming a connection is active? Yes. Do I want the option to toggle always online on/off? Yes. Do I want a system that allows me to play my purchases on or offline? Yes. Do I want system that allows me to play games (disc or on-demand/arcade) from the immediately previous generation? Yes.
Do I want a system that requires an active connection to play a game? No. Do I mind that I won't be connected to Live and won't achieve achievements? No. Do I want to get kicked out of a single player game when my mother in law unplugs the router? No. Do I want my playing habits monitored and displayed for the world to see? No, but that might change so let's make it an option.
The tone of finality that's displayed sometimes is a little overboard considering that we do not know any of what's been said as fact. They range from speculation to hypothesis to trolling (in Orth's case).
All that said, I likely won't be purchasing a next-gen system on launch. Early entry fee, backlog and general issues always give me pause. Right now the rumor mill does have me concerned, but this is almost always what happens with each generation.