While I do think Obama is trying to present a 'changed" USA, one that is more open to countries we haven't typical strongly associated with, and less dependant upon old allies, I don't think he has any particular problem with the UK. I.e., I'm not sold on any colonial resentment from his father or grandfather.
I do think he is far more ackward, and waaaaay less intelligent, slick and charismatic, than many initially gave him credit for. I think many of the items on your list are doofus type blunders by him or his staff, not intentional offenses.
I think his recent comments about Israel and '67 borders is another example of that. Apparently, he thinks he said the same thing as GWB and Bill Clinton. However, if you listend closely he glossed over some pretty dang important v to the Israelis, such as their security and just went to the '67 border part. Bush and Clinton both had plenty of caveats to their suggestion, Obama didn't. Clumsy, and his inexperience shows almost daily.
Fern