'USA should never have been in Middle East' president tweets, amid scathing bipartisan criticism for withdrawing forces, and mounting concern in Israel