Romneycare never really had widespread support of Republicans at the national level. Or, really, the support of Republicans in general. It was passed by a governor in a state where almost every single elected state legislator is a Democrat, so it's hardly a measure of what to expect Republicans to support when the population they represent is more moderate, conservative, or Republican-affiliated.
Using Romney's actions as governor of MA as a yardstick is a really skewed perspective to try and apply to national politics. Massachusetts has a history of electing Republican governors as a way of placing a "check" on the legislature. Currently, Massachusetts has a Republican governor - but Baker would likely have run under the Democratic party if we were talking about Montana or Kansas instead of Massachusetts.
> and some center-left Democrats (most Democrats wanted a single payer plan, or at least a public option, but took what they could get because the healthcare system was/is at a breaking point)
It was never the case that "most" Democrats wanted a single-payer plan. The public option was more popular within the Democratic party, but even then was very controversial, and didn't have strong enough support from the Democrats.
There was, incidentally, a proposal that did have bipartisan support (the Wyden-Bennett bill), but it fell short of 60 votes.
You’re right that the ACA ended up being a political disaster for the Democrats though.
The ACA was basically the same as “RomneyCare” in MA, and was a style of healthcare reform supported by mainstream center-right Republicans and some center-left Democrats (most Democrats wanted a single payer plan, or at least a public option, but took what they could get because the healthcare system was/is at a breaking point), but once Obama’s name was on it they all decided to throw everything they could against it.
The GOP campaigned hard against the ACA after it passed, and won massively in the midterm elections in 2010 on the back of wall-to-wall anti-ACA messaging on right-leaning media and a huge amount of organizing and spending (the first post-Citizens United election). They took control of the House, Senate, and many state legislatures, following which they redrew all the district boundaries to cut Democrats permanently out of competition in the House and many state legislatures.
After the crushing defeat in 2010, there weren’t enough Senate seats up for grabs in 2012 for the Democrats to regain control. Thus Obama had to deal with 6 years of GOP control, which has been the most obstructionist Congress in US history. As soon as McConnell won in 2010 he publicly declared that his #1 goal was to make Obama a 1-term president. We had multiple government shutdown threats, unprecedented obstruction of executive appointments including judges at every level of the federal court system, bogus investigation after bogus investigation into e.g. Benghazi, and dozens of purely symbolic votes to repeal the ACA.