I think it could be President James Dale from 'Mars Attacks!' He was pretty ineffective and made some really bad decisions.
For me, it might be President Merkin Muffley in 'Dr. Strangelove.' His indecisiveness and inability to handle the crisis situation made him one of the worst. Also, his character seemed rather weak and ineffectual in dealing with the escalating tensions.