Since not a single republican voted for the ACA I don't think the republicans got "what they wanted".
Also, Obama doesn't want what Canada has: In Canada's system everybody, from the PM down to the normal citizens, use the same system. That would never happen in US. As Obama said when he was trying to pass it he is perfectly happy with his own health care. Healthcare isn't his problem, it's "the problem of uninsured". He and everybody else in power would continue going to their private doctors. Only the rest of us would deal with the the health care system.
And lastly I think he's happy with what was passed. My personal theory on the ACA is that it was about creating a new union, public or other wise, out of the country's doctors/medical providers thus creating a permanent voting block for his party long after he is gone from office (or at least revenue stream via union dues). Obviously a ridiculous notion.