Has the electoral college worked as intended and should it be revoked?

No, the electoral college does not work as intended, either in how it functions or in the result which it returned in 2016.  In fact, Trump is precisely the kind of person who the Founding Fathers thought should never ever be President and who the electoral college was, partially, invented to stop. 

The intention of the electoral college was never to ensure that "small states" had a say.  Nor do current justifications for the college, such as the one you echo, hold any water.  You argue that the electoral college is important because it keeps a few cities from dominating the election and controlling everything.  This is absolute total nonsense.  Chicago, New York and Los Angeles have a combined population of less than 15 million people.  That's less than one tenth of the votes cast in this last election.  And that's assuming that all the people in those cities could vote (which they can't) and that they all vote the same (which they don't).  Joe Biden got 80 million votes in November.  Hillary Clinton got IIRC 65 million in 2016.  Anyone hoping to win the Presidency needs a broad coalition which encompasses more than a few cities. 

The reason that the electoral college was created was that in the 18th century, where newspapers were few, literacy was spotty, and the mail still patchy, the founding fathers feared that many voters would lack the broad scope of knowledge that would be necessary for them to chose a potential president.  They feared that these people would either pick local candidates who they knew about, or might be seduced by demagogues who played on their emotions.   The electoral college, which they assumed would be made up of the "better sort" of men, would substitute their supposedly superior judgement for that of the people.  They were supposed to actually choose the President.  But that's not how it works anymore.  The electoral college has become an unthinking rubber stamp, and because of how it functions today, we can get abominations such as 2000 and 2016 where the candidate who was rejected by the voters is nonetheless elevated to the Presidency.  The Founders would have been horrified at the result of 2016, both because the candidate who had so clearly been rejected by the people became President, but also because someone like Trump, a corrupt, ignorant, idiotic, corrupt, profligate, corrupt, bullying, corrupt, ignorant, huckster and con man would become President.

The flawed electoral college was a mistake from the beginning and needs to be eliminated.

has Affirmative Action "worked as intended?"....and should any flaw be used as reason to revoke it?

both were formed under the same principle...that minority voices need to be represented...