For the sake of calm on the forum, we had best keep this discussion and predictions polite and limited.
The general consensus so far is that only a few things will take effect in the short term, with the rest of it stretching out over several years. In the meantime it will probably get revised several times. Don't look for an insurance exchange in your state any time soon, and the hot-potato rule about having insurance or paying a tax penalty won't take effect until 2013, if it turns out to be a keeper.
The short term effects, which will be generally popular, are curbs on insurance companies being able to deny coverage for existing conditions, rules to cover children until age 26 on their parents policy, and an increase in prescription drug coverage for seniors. Other than that, as the New York Times put it, "most Americans with insurance are unlikely to see any immediate change in their coverage." Long term is another question, and the dust has to settle down a lot before anyone can really say.
I do think that having an acoustic neuroma will be less of a barrier to getting medical insurance from now on, and that at least is a good thing.
Steve