Jewish filmmaker, also known for Oscar-winning 'French Connection,' struggled in later years but maintained support for Israel, directing an opera in Tel Aviv