I pretty much agree with everything you said, with the exception of Obama being an awful president. From a conservative standpoint, sure; but from a moderate or liberal standpoint, he hasn't been awful - good to mediocre maybe, but not awful.
He has managed to accomplish a lot - especially when you consider the obstructionism he faced from congressional Republicans. Sure, the first year or so of his term, he had a majority in both houses; but in the senate, it was a small majority (by senate standards), which meant that Democrats had to waterdown a lot of legislation to get enough moderate Republicans to vote with them.
Republicans have proven time and time again that they have no interest in working with this president - even on lehislation that was originally their idea. It's going to take a lot more than folding arms and stomping feet for Republicans to convince America that they deserve to run the country.
And on top of those legislative victories, he has a number of foreign policy achievements under his belt that will undoubtedly appeal to people of all political stripes; Bin Laden, Ghaddafi, and any one of the killed or captured AQ leaders could attest to that.
But here's the thing, he really couldn't get things accomplished when he controlled both houses of Congress by healthy margins. He let Pelosi and Reid take the lead, with the disasterous results that followed.
Of course, the opposition party is going to act like an opposition party. And a Smart President learns how to triangulate. (Sweet Evil Jesus, I'm citing Clinton as a good example?) If there's been too much foot stomping, there's been too much foot stomping on both sides.
Even when I agree with him on something, the way he handles things is awful. I think he's perfectly inthe right on his fight with the Catholic Church on Family Planning Coverage. And 75% of Catholics probalby agree with him. But the way he handled it, was simply awful, and he ended up looking like he was bowing to the Bishops instead of standing his ground. (Even though in reality, he gave very little ground on the issue.)
Now, for his foreign policy- yeah, it hasn't been that bad. But that was because he didn't listen to himself. He kept Bush's polcies and Bush's team, and Hillary has done a remarkable job as Secretary of State. The people he opposed saved him from himself.