You are confusing the Six Day War (1967) with the Yom Kippur War (1973). Yes, President Richard Nixon will forever be remembered as a great friend of Israel. Had he not been so loyal to his people and thrown a few to the wolves Watergate would have blown over and he probably would have gone down in history as a great President in most every respect.
I also don't think most Democrats would sell out Israel. Most have been strong supporters of Israel, including some of the ones most hated on FR. They Cynthia McKinneys and Fritz Hollings are the exception, not the rule. You have similar exceptions among Republicans. (Brent Scowcroft, Ron Paul, James Baker immediately come to mind.) Having said that there is no doubt that some of Israel's strongest support comes from the Republican party.
Wow, Nixon was great? Yes he rescued Israel with arms shipments but it was only after delaying the shipments long enough to leave Israel in a desperate position.
In terms of his presidency he should be considered one of the worst Presidents in American history (and I vote Republican 95% of the time). He imposed wage and price controls even though he knew they would be a disaster. He continued the Viet Nam war, knowing that Viet Nam would fall eventually but that he would no longer need to be elected by the time it happened costing thousands of lives of young American soldiers (not to mention Vietnamese). He was about as cynical a politician as ever lived. Those who admire a corrupt politician like Sharon might admire Nixon but those who have at least minimal standards will pass on him.