I don't really have an opinion on when the will of the majority ought to be "ignored." However, it is significant that the constitution of the United States is written to protect against both majoritarian and minoritarian tyranny.
The Electoral College reduces majoritarian tyranny sighificantly, and for all that people often complain of it, it was absolutely necessary to secure the ratification of the constitution. At the time that the draft of the constitution was sent out for ratification, the state of Virginia had the largest population, with Massachusetts not far behind. Between them, in an absolute majoritarian democracy, Virginia and Massachusetts could effectively have chosen the President, chosen all of the executive officers and written all of the legislation. They could have amended the constitution at will. They could have dealt between one another to accomplish these ends, and dictated foreign policy as well--all while ignoring the rest of the states.
The representatives of the other states were not dumbies--they knew this, which is why the Electoral College and the provisions of the powers of the Senate were necessary to secure ratification. In particular, the Electoral College assures that all the states have a significant role in choosing the President, and that no mere populous coalition can dictate to the rest of the nation. As the demographics of the United States work now, without the Electoral College, the megalopolis which stretches from Boston to Washington, Florida, Texas and California would elect every President, and the rest of the country could go try to piss up a rope. Without the Senate, the Representatives of those same states would have the control of the Executive cabinet and all foreign policy.
If the President--who is chosen by the several states as much as by the people at large--vetoes a bill, it requires a two thirds vote to override that veto. Washington want a four fifths provision, but the convention wouldn't have it. It works well enough as it is, and a four fifths provision would make the Presidential veto nearly bullet-proof. Three fifths of the several states must ratify amendments to the constitution. Once again, this prevents a coterie of populous states or areas from colluding to create the government they want while the rest of the country is free to be damned.